Use List of Words to Filter from Data Set

[schoi419]

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.93oz

5 Hour Energy Berry Extra Strength 1.93oz

5 Hour Energy Grape Extra Strength 1.93oz

5 Hour Energy Pink Lemonade 1.93oz

5 Hour Energy Sour Apple Extra Strength 1.93oz

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

Sam

[JosephSerpis · Accepted solution]

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

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.

[schoi419]

This worked perfectly! So simple! Thank you!

[schoi419]

Wonderful! Thank you!