Mapping from Key words

[Learner09]

Hello All,

I am trying to create Mapping with the help of keywords. Please see the details in the attached file.

Thanks,

[JulioMO · Accepted solution]

Hi @Learner09 

Try to use a "Formula Tool" to create a new column with the following formula:

IF Contains([Updated Item Description], "Absence") THEN "Absence"
ELSEIF Contains([Updated Item Description], "Analytics") THEN "Analytics"
ELSEIF Contains([Updated Item Description], "Accruals") THEN "Accruals"
ELSEIF Contains([Updated Item Description], "HR") THEN "HR"
ELSE null()
ENDIF

Hope it helps!

Regards

[messi007]

@Learner09,

Please see below:

Attached the workflow,

Regards

[Learner09]

Thank you @JulioMO