Keyword search in multiple fields

[Meena]

Hi

I have a requirement to search a keyword (from a lookup file with many records) in multiple fields (Input file) and append the keyword to the input file if keyword is found in any of the fields.

For interim I have concatenated the fields in input file to 1 string (Birth City + Current City) and use File-Replace on the concatenated string.

Please help me if there are any other options available.

Example :

Input File

Birth City	Current City
Virginia	NewYork
Denver	Seattle
Ohio	Ohio
NewYork	Toronto

Lookup File

Keyword

New York

Ohio

Output after search should append Keyword to Input File as below,

Input File

Birth City	Current City	Keyword
Virginia	NewYork	NewYork
Denver	Seattle
Ohio	Ohio	Ohio
NewYork	Toronto	NewYork

[Gaurav_dup_112 · Accepted solution]

Hi @Meena,

I am attaching the solved workflow. I hope it helps. Revert for any queries

[danrh]

Here's another option.  A few more tools, but it can handle any number of fields in the input and allows for multiple keywords to be identified in different fields for a single record.

Hope it helps!