Filter Data Based on Excel Keyword List

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,

Example Workflow for Filtering3.yxzp

Data Investigation

Accepted answers

Simha

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

Regards

Simha

Example Workflow for Filtering.yxmd

All comments

Simha

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

DavidP

Try this

Example Workflow for Filtering.yxmd

DavidP

After the summarize, you have to remove the quotes.

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

Simha

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

Regards

Simha

Example Workflow for Filtering.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703