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?
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