Filter Data Based on Excel Keyword List

[bracks04]

I would like to filter data based on a list of keywords that I maintain in excel where the list from excel is used to build the filter.

I've concat the keywords and added to each row of the data but cannot seem to get the filter to appropriately work to return all results that contain the keywords.  

I would expect to filter and return Sale 1, Sale 2, Sale 3, Sale 5, 

[Simha]

Hi, I am unable to download your attachment. It gives error 'No attachment or failed to download'

[DavidP]

Try this

[DavidP]

After the summarize, you have to remove the quotes.

Also, split items sold to individual items with a text to rows.

[Simha · Accepted solution]

Hi, You can use the 'Find/Replace' tool to achieve this as shown in the attached workflow.

Regards

Simha

[bracks04]

Thanks DavidP.  Looks like it came out for identifying the records, but was wondering if there was a way to do it more like a "Contains" function so I can keep the full set words together within the "Items Sold" column.  I'd eventually like to add a column to the original data that marks the Sale Record as "Produce".

[DavidP]

You have to isolate the items to test for each individually, but if you add in a recordID right at the start, you can join the filtered result back to the original dataset.

[DavidP]

Something like this.

But I think @Simha's solution is way more elegant.

[Simha]

@DavidP, thank you for your feedback. Appreciate it.