topic Re: How to add multiple keywords in the loading scripts? in QlikView

How to add multiple keywords in the loading scripts?

jim_chan — Mon, 31 Oct 2016 08:08:26 GMT

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 — Mon, 31 Oct 2016 09:07:37 GMT

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

Regards

Anand

jim_chan — Tue, 01 Nov 2016 06:25:20 GMT

here. i have posted here.

MarcoWedel — Tue, 01 Nov 2016 22:58:38 GMT

maybe like:

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

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

regards

Marco