Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
If(risk_desc like '*chicken*' or risk_desc like '*beef*', 'Favourite Meat') as Keywords
If(WildMatch(risk_desc, '*chicken*', '*beef*'), 'Favourite Meat') as Keywords
If possible provide some sample data or the inline data to have a look on the solution.
here. i have posted here.
Re: Create keywords(*BUSINESS*) from column data.