AnsweredAssumed Answered

Filter documents based on "whitelist" / list of valid entries

Question asked by kbu759182 on Dec 20, 2016
Latest reply on Dec 20, 2016 by kbu759182

Hi there

 

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!

Outcomes