Keyword search in multiple columns

[Ranjan88]

Hi All,

I have come with a solution to search the keymowrd in multiple columns. I just wanted to know is there any better way i can get this done. because i have 1000 of Keywords need to search.

Your help would be much appreciated.

Thanks,

Ranjan

[fmvizcaino]

Hi @Ranjan88 ,

Only to simplify your condition, I would concatenate all 3 columns into one to make it easier for you to right your condition.

But you can also use a support dataset with a find replace tool to insert names based on a substring.

Best,

Fernando Vizcaino