Data for Contains formula via user input/text input tool

[hussainamreliwala]

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 solution]

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 solution]

Thanks a lot, it is working perfect fine now 👍

[atcodedog05]

Happy to help : ) @hussainamreliwala 

Cheers and have a nice day!