This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I have 2 columns of data. The first is essentially an ingredient list.
For example a values will be like 40% corn, 30% flour, 10% oil, 5% apples etc
The 2nd column is a dynamic list the user will update periodically on what I want to filter on
What I want to do is check the values in the 1st column to see if it contains any of the values in my 2nd column and keep those rows. My first challenge is the values in the first column are not standardized so the syntax (eg flour won't just be flour it'll be gluten free flour) & location (from the 1st ingredient listed to the last) of the values i want to filter constantly change. The 2nd is the list of values I want to filter on will constantly change as well.
Any ideas how I can do this? It'd be great if I could do some sort of conditional join tool
Using an iterative macro workflow that I've built a few months back for another use case, it seems to also work for your use case.
If you take a look at the attached workflow, just simply ignore the header name for both datasets (I did not bother to change it for now and simply want to test out if it works for your data). I change the data to your data for both input data, run the workflow and it will try to loop through the dynamic list (input_data_2) and see if a particular item is found.
As an output, you can see that every category that can be found from input_data_2 will be concatenated as the last column:
Let me know if this is what you want?
iterative macro - looping find and replace to find keywords.yxzp