Find multiple values in string

[SagarGite]

Hello team,

Looking for the workflow or tool which can perform recursive search (expecting exact match) in input 2 for the values present in Input1 and Append them with records as shown in expected output.

Please see attached file for Input1, Input2 and  Expected output.

Thanks in advance

[LukeG · Accepted solution]

Here is an example that appends each of the search words to the text. If the word is found in that text string, the record is kept in the data set and we aggregate the data back together to return your desired output.

Please let me know if you have any questions.

Best Regards,

Luke