Sub Query Comparing two lists
Hi Everyone,
I’m a bit stuck. Basically, I retrieve a list of people who have a flag set to true (list A). Then I get a list of active cases from CRM (List B). Then I want to check if the customer ...
Forum Discussion
Another possible approach is using the In-Memory Lookup snap. Again, this operates on lists of documents, so you might need to split your lists. You give list A to the first input, and list B to the second input. The In-Memory Lookup operates a bit like a SQL left outer join. If a document from input view A matches a document from input view B, it will output a document that combines the two, otherwise it will just output the document from view A.
