Set of keyword search in Excel


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.


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


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”

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

unable to use contains


Are you getting any error ?

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


CheckIfRowContainsString.xaml (11.8 KB)
Please find my workflow


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

Could you please share your file and will check it.

CheckIfRowContainsString.xaml (11.8 KB)


I modified your workflow. Please find the same.

You didn’t iterate that strkeywordsArr array.

CheckIfRowContainsString.xaml (14.4 KB)

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


Please send me your excel file.

inputDT.xlsx (8.0 KB)

Any hope


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


Please find the attached workflow.

CheckIfRowContainsString.xaml (16.5 KB)