LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jpstory

Hi, All

I need to exclude certain records if their ID codes are on a black list ( a separate file maintained by someone else and changes every day)

The problem is:
1. The list contains 1000+ such ID codes (eg. 1EKXHD8009K), so I can't hard code them into a Filter node.
2. There are 2 fields Buyer_ID and Seller_ID, that I need to look at, if either one is on the black list then it must be excluded.
That means I need to do 2 separate Join on Buyer_ID and Seller_ID and then bring them back together and remove duplicate

3. I need to repeat the process several time further down as I have multiple such black lists associated with other fields .....

Is there any way I can create an Array to load the lists at Run Time and able to use the Array in a Filter Node ? It appears using parameters is out of option as parameters are static ?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Attached is one solution, others are possible.
Attachments:
List Compare.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jpstory

This is awesome ! Thanks!