Hi, need help to get difference records between 2 lookups with same column name.
ex: lookup 1 has the data below:
lookup 2 has the data below:
if anything new shows up in lookup1 which is not found in lookup2, I would like to know what value is being outputted.
Can you help?
@jiagya, you can try the following to get numbers which are not in
lookup2 but in
| inputlookup lookup1.csv where NOT [| inputlookup lookup2.csv | table number]
Just FYI, if you want results which are in both lookup1 and lookup2 then you just need to take out
NOT from the above query.