Outputnew: How do I compare two Fields in two Lookup tables?

[russell120]

Hello,

I need help finding out how I can display field values of one lookup that are not present in the same-named field as another lookup.

Ex: lookup1.csv has the below data.
Field: colors
red
orange
yellow

Ex: lookup2.csv has the below data.
Field: colors
orange
red
green
blue

The results should display yellow because yellow is a value within the colors field of lookup1.csv , but is not a value in the colors field of lookup2.csv.

Thanks.

[russell120 · Accepted solution]

|inputlookup lookup1.csv
|lookup lookup2.csv colors OUTPUTNEW colors as Missing_Colors
|where isnull(Missing_Colors)

Ah, this did the trick.