topic RE: Find value from collection in Email Body in Product Forum

Find value from collection in Email Body

MoDCore — Mon, 20 Apr 2020 11:38:00 GMT

Hello All,

I am trying to categorise emails based on key words from inside the email body.

If I hardcode the values it is looking for then the process works as expected.

Now the next step is to have the keywords which define a category in a locally managed file.

I would of thought putting the list of key words into a collection.

To then add that collection to my choice stage

But this isnt working as expected.

There is 7 categories, with undefined number of key words (as this is likely to gorw as we progress over time).

Any suggestions or guideance on this would be great.

Thanks

------------------------------
Matthew Ross
Principal Innovation Developer & Analyst
NHBC
Europe/London
------------------------------

RE: Find value from collection in Email Body

IanCampbell — Tue, 21 Apr 2020 06:51:00 GMT

Hi Matthew,

The above logic should work with one minor change. In the first image above you are asking it to find [String_A] in the emai_text OR [String_B] in the email_Text, as this is basic string matching this works as expected, however in the third image you are asking it to find a column of a collection in the email_text, which will cause an error as the data types are not compatible in this way.

To fix the above, use a loop stage and set it to loop through your collection of keywords, then move the decision stage containing the logic (image 3) between the open and close of the loop. This will then go through the collection one row at a time, allowing the keyword in each row to be searched for individually.

Hope this helps with your issue.

Kind regards,

------------------------------
Ian Campbell
RPA Specialist
Allen & Overy
------------------------------

RE: Find value from collection in Email Body

zdenek.kabatek — Tue, 21 Apr 2020 07:17:00 GMT

Hi, Matthew,

did you think about using Filter collection to get the right rows?

Regards,

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------

RE: Find value from collection in Email Body

MoDCore — Tue, 21 Apr 2020 07:41:00 GMT

This sounds like a plan to me!

Will work on it today and report back with my findings.

Think i was looking at it too much and could see the simple loop path.

Thanks
Matthew

------------------------------
Matthew Ross
Principal Innovation Developer & Analyst
NHBC
Europe/London
------------------------------