I have a process where I am retrieving a large number of XML documents and I need to filter these based on profile element (Number). If the document Number exists in a "whitelist" (this is a flat file containing valid numbers), send down one path, if not send down another path.
I thought I could use Route shape and Equals for the purpose, but it seems not to be the case. Then I tried Decision shape and loading the whitelist into af Cross reference table and then doing a lookup, but I stuck with it just comparing based on the first value.
This seems like a really simple process, but right now I am stuck...! Tried searching but I can't find a similar problem (probably because it is very simple...!), so if someone could point me in the right direction, I would be very grateful!