Checking key words

Dear all,

I have attached a sample file contains 3 sheets which are (Input, Key word, Output). What I'm looking for is to have a workflow with two inputs which are (Input sheet and Key word sheet) then the workflow will check from the input sheet is these is any word key in the DEC if yes the workflow should give me in the output the DEC with Profile column as shown in the output sheet.

So, the workflow will check the input file in the DEC column and check if there is any key word which exist in the key word file if yes add a column and write the profile which is beside the key work column in the key word sheet.

Any help in that please?

Sample.xlsx

Workflow

Output

Help

Udacity

Accepted answers

atcodedog05

Hi @Feras95p

Here is how you can do it.

Workflow:

Hope this helps : )

Profile Match.yxmd

atcodedog05

Hi @Feras95p

You can do something like this.

Workflow:

Hope this helps : )

Profile Match (1).yxmd

atcodedog05

Hi @Feras95p

Here is how you can do it.

Workflow:

Hope this helps : )

Profile Match (1) (2).yxmd

Sample (3).xlsx

All comments

atcodedog05

Hi @Feras95p

Here is how you can do it.

Workflow:

Hope this helps : )

Profile Match.yxmd

atcodedog05

Happy to help : ) @Feras95p

Cheers and have a nice day!

Feras95p

Hi @atcodedog05 ,

Thanks for helping ! I tried it on my actual data and I got only 37 out of 11248 ! Any idea why?

WhatsApp Image 2022-01-09 at 6.57.00 PM.jpeg

atcodedog05

Hi @Feras95p

I am not sure. If the word is exact then it should match. Check once in excel apply the filter on the column and check whether the keyword exists in the DES and are you getting a different number of rows in that. The keyword should be exact (same case and characters) if it's not it will not catch.

Let me know how it goes.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703