Filter Data set with excel file, criteria with Regex

Question

Hi,

I stuck with resolving a situation in which there is need to filter a data set, and to avoid modifying the workflow each time the criteria changes I decided to use an excel file with a list of the criteria, the thing is, the criteria is like 5* or 654*, it mean we wanna see only the ones where the data start with 5 or 654. The filtered data will contain code numbers, held as string.

Would appreciate any kind of support on this.

lukamso · Accepted Answer

Thank you, but i was not able to make this solution work on my project, probably cause of my short knowledge of macros in Alteryx.

Although I resolved the issue just by appending these two data sources, then adding a new column with formula StartsWith(String, Target), then filtering it to get just the True values ;)