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.
|inputlookup lookup1.csv
|lookup lookup2.csv colors OUTPUTNEW colors as Missing_Colors
|where isnull(Missing_Colors)
Ah, this did the trick.
|inputlookup lookup1.csv
|lookup lookup2.csv colors OUTPUTNEW colors as Missing_Colors
|where isnull(Missing_Colors)
Ah, this did the trick.