How to add multiple keywords in the loading scripts?

[jim_chan]

Hi guys,

I have no issues creating keywords as below:

if ( business_desc like '*Chili*Chicken*' , 'Spicy Chicken' ) as Keywords

but what if now i have 1 row data -

If( risk_desc like '(*chicken*|*beef*)', 'Favourite Meat') as Keywords

like compound search.

how should i write in loading script, or is it possible?

rgds

Jim

[its_anandrjs]

If possible provide some sample data or the inline data to have a look on the solution.

Regards

Anand

[jim_chan]

here. i have posted here.

Re: Create keywords(*BUSINESS*) from column data.

[MarcoWedel · Accepted solution]

maybe like:

If(risk_desc like '*chicken*' or risk_desc like '*beef*', 'Favourite Meat') as Keywords

or

If(WildMatch(risk_desc, '*chicken*', '*beef*'), 'Favourite Meat') as Keywords

regards

Marco