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.
Ex: lookup2.csv has the below data.
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.
|lookup lookup2.csv colors OUTPUTNEW colors as MissingColors
Ah, this did the trick.
View solution in original post