Hi, need help to get difference records between 2 lookups with same column name.
ex: lookup 1 has the data below:
columnname: number
one
two
three
four
lookup 2 has the data below:
columnname: number
one
two
three
five
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?
John.
| inputlookup lookup1 | lookup lookup2 number OUTPUTNEW number as isFound | where isnull(isFound)
@jiagya, you can try the following to get numbers which are not in lookup2
but in lookup1
| 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.
Ok, Thanks for the tip Niket
| inputlookup lookup1 | lookup lookup2 number OUTPUTNEW number as isFound | where isnull(isFound)
Thanks..... Worked like a charm.
That worked as expected, thank you
John.