Checking key words

[Feras95p]

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?

[atcodedog05 · Accepted solution]

Hi @Feras95p 

You can do something like this.

Workflow:

Hope this helps : )

[Feras95p]

Hi @atcodedog05 ,

Hope you're doing well, I was wondering now instead of using priority if I have two keywords in one cell (DES), can I have a workflow that duplicates the the cell and for each cell give the profile of the keyword like the sample file attached?

In the sample file in DES I have two keywords for different profile so the output is duplicate the DES and gives each Bold keyword its profile.

Note that, it should be applied for the more than keyword exact in the same cell with different profile.

[atcodedog05 · Accepted solution]

Hi @Feras95p 

Here is how you can do it.

Workflow:

Hope this helps : )

[Feras95p]

Hi @atcodedog05 ,

Thanks for helping, for the sample data it works great but when I tried the actual data it gave me this error! Any idea?

[atcodedog05]

Hi @Feras95p 

Configure append tool like below. And let me know does it work.

Hope this helps : )

[Feras95p]

@atcodedog05  Thanks the first error solved, but the second one which is N Dimensional Join still as shown in the pictures attached . Any idea how it can be fixed?

 

[atcodedog05]

Hi @Feras95p 

The possibility is you might have null rows. Try this workflow.

Hope this helps : )