Search keywords in a report

Help Studio
,
1

Hi there,
I’m looking for ideas to automate the following process:

We have a report of all expense claims made by our employees, we would like to search for keywords in the comments of these claims. If a keyword is found, then we need the value in the next column to decide what action to take.

This is what the keyword file would look like:
KeywordFile

This is what the comments could be:
Comments

If no keywords have been found, then the claim is OK and we don’t need to do anything.
If a keyword has been found, then we need to make a queue item for it with the value of ‘Action’. (And a lot of other transactiondata)

I’m having trouble to come to ideas for this. I’m wondering what you guys think.
How to search all the keywords in a comment? Regardless if its with an upper or lowercase for example.

Thanks in advance,
Regards. Guus

2

Hi,

I think something like this should do the trick:

image
image568×867 22.9 KB

Just make all keywords lowercase

1 Like
3

Thank you @Obsev! It allmost worked; I only needed to change the last assign activity. You used row(“Action”).Tostring and it should be key(“Action”).Tostring.

Just tested it and it works fine!
Thanks for your help.
Regards, Guus

4

Ah my mistake, but good that it worked :slight_smile:

1 Like