Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
If possible provide some sample data or the inline data to have a look on the solution.
Regards
Anand
here. i have posted here.
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