Data for Contains formula via user input/text input tool

Question

Using below formula to filter out data for specific ID

CONTAINS([ID],"D123456") OR CONTAINS([ID],"D123457") OR CONTAINS([ID],"D123458")

Problem:-I am having 30 id's, so instead of copy/paste 30 Times is there a way out

1.where user can fill this data in Alteryx OR

2.I can paste them all together in text input tool and take from their to the formula tool OR

3.Find and replace tool

atcodedog05 · Accepted Answer

Hi @hussainamreliwala

You can use join tool for this. You can have a list of IDs and perform an inner join on data and ID list this way you will only get matched IDs.

Note: Please make sure the ID list has only unique values

Hope this helps : )

hussainamreliwala · Accepted Answer

Thanks a lot, it is working perfect fine now 👍