How to compare 2 columns between 2 lookups?

[jiaqya]

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.

[niketn]

@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.

[jiaqya]

Ok, Thanks for the tip Niket

[starcher · Accepted solution]

 | inputlookup lookup1 | lookup lookup2 number OUTPUTNEW number as isFound | where isnull(isFound)

[computermathguy]

Thanks..... Worked like a charm.

[jiaqya]

That worked as expected, thank you

John.