Filter based on a list of values contained in a list / column

[Katy_Holder-Vale]

I have a dynamic list of suppliers and want to use this to filter some data in another workstream.  I can hard code this using the "Value In" operator - ([Supplier_ID] IN ('A1','A2',A3','B4',X5')) which is fine but not great.  What I would prefer is to import this list from the other workstream and have this drive the filtering funtion.  This would look something like ([Supplier_ID] IN [Sullpier_List]).

I am sure that this is possible but does anyone know how?

[messi007]

@Katy_Holder-Vale,

You can use a join based on the Supplier ID and the supplire list the J output will display the matching rows.

Hope this help!

Regards

[dougperez]

A simple join wouldnt do that? Join the two datasets with Supplier_ID and then use just the J output