Use List of Words to Filter from Data Set

Question

Hello,

I was hoping to look for all the keywords in the "List of Words" file within the "Data" file. I would like to use a filter so that only the entries containing the keywords are left and all the entries without the keywords are separated out. For example, if "5 Hour Energy" is a keyword, then I would pull of the entries with that keyword:

5 Hour Energy Berry 1.93oz5 Hour Energy Berry Extra Strength 1.93oz5 Hour Energy Grape Extra Strength 1.93oz5 Hour Energy Pink Lemonade 1.93oz5 Hour Energy Sour Apple Extra Strength 1.93oz

Any guidance on this would be much appreciated! Thank you in advance!

Sam

List of Words.xlsx

Data.xlsx

JosephSerpis · Accepted Answer

Hi @schoi419 the Find and Replace tool might help you with this. I mocked up a workflow let me know what you think?

grazitti_sapna · Accepted Answer

Hi @schoi419,

you can make use of find Replace tool with the Append Fields to Record option and later on you can make use of the filter tool to filter out the non empty values from the List column. I have made a sample workflow for the same.

I hope it helps.