Set of keyword search in Excel

Help
1

Team.

In excel particular column i want to apply keyword search.

say for example the first keyword “login” if it is found then it should create a new column with value as “functionality”(if possible i want to apply some set of keyword search like login/signin/password , if any of the keyword is exist it supposed to create the value as “functionality”

Next keyword is “access” then it should create the value as “security” in the same column.

2

@KavithaManivel,

Create one array with all those key words and then compare it with excel column.

If row(“KeywordColumn”).toString.equals(strkeywordsArr)
Then proceed
Else skip

3

Hi,

I tried similar way but output not appropriate
see if have created array like {login, signin, password}
used if condition
my column contains description “issue in the login page”
the ouput column should be “functionality” but its printing the else “value”

4

Try this one: row(“KeywordColumn”).toString.contains(strkeywordsArr)

5

unable to use contains

6

@KavithaManivel,

Are you getting any error ?

7

no accessible “Contains” can be called with these arguments.

However i have given direct search cleared everything and just kept "login " in the description but still it prints the defualt value for this below code

row(“Name”).toString.equals(strkeywordsArr)

8

CheckIfRowContainsString.xaml (11.8 KB)
Please find my workflow

9

@KavithaManivel,

Try this: row(“Name”).toString.Trim.equals(strkeywordsArr)

Could you please share your file and will check it.

10

CheckIfRowContainsString.xaml (11.8 KB)

11

@KavithaManivel,

I modified your workflow. Please find the same.

You didn’t iterate that strkeywordsArr array.

CheckIfRowContainsString.xaml (14.4 KB)

12

Nope. Not working. Even iteration is also not perfect. Again its placing the else value

13

@KavithaManivel,

Please send me your excel file.

14

inputDT.xlsx (8.0 KB)

15

Any hope

16

@KavithaManivel,

I am busy with some production issues. So, I did not check but will give do it and provide solution. Please give me sometime.

17

@KavithaManivel,

Please find the attached workflow.

CheckIfRowContainsString.xaml (16.5 KB)