Hello all,
I had a question that I have been trying to figure out how to address within a concise SPL query.
I have two lookups with a field name of X, lookup1 and lookup2 have all these values populated and I am trying to find a query to output the difference in field values for X between the two lookups.
lookup1's X value has a Multi-value field, where as lookup2 is only single values.
E.g.
Lookup1 has field values:
Banana
Apple
Oranges
Lookup2 has field values:
Banana
Expected output from desired query:
Apple
Oranges
Is there a way to do this between these two lookups with the above in mind? This seems feasible with one lookup, but comparing two lookups has proven to be difficult. Any support would be appreciated!
... View more