Archive

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

Communicator

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.

Tags (2)
0 Karma
1 Solution

Communicator

|inputlookup lookup1.csv
|lookup lookup2.csv colors OUTPUTNEW colors as MissingColors
|where isnull(Missing
Colors)

Ah, this did the trick.

View solution in original post

0 Karma

Communicator

|inputlookup lookup1.csv
|lookup lookup2.csv colors OUTPUTNEW colors as MissingColors
|where isnull(Missing
Colors)

Ah, this did the trick.

View solution in original post

0 Karma