Compare a column to a column from a lookup table

[ondohotola]

Having no idea about luau I am currently struggling (related to #2450). I want to remove all records from one table (input) for which the primary key is same as the one from a second CSV (pgg) to later cat them together again.

I can do a qsv_loadcsv("pgg", "pgg.csv", "FQDN") successfully (I think).

Now how do I compare the first column of the input (helpfully also called FQDN (unique)), with all FQDN values of the pgg table (also unique) returning false if found?

[datatraveller1]

This sounds like a task for my favourite qsv commands left-anti, left-semi, right-anti, right-semi (in this case join --left-anti).

I have created the most basic possible example.

file fqdn.csv:

fqdn,value_fqdn
9,value1
4,value2

file pgg.csv:

fqdn,value_pgg
2,value1
9,value2

command:
qsv join --left-anti fqdn fqdn.csv fqdn pgg.csv

result:

fqdn,value_fqdn
4,value2

[ondohotola]

Yes of course, thank you.

-i is helpful too :-)-O