Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jim_chan
Contributor III

How to add multiple keywords in the loading scripts?

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

1 Solution

Accepted Solutions

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

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

3 Replies

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

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

Regards

Anand

jim_chan
Contributor III

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

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

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

Community Browser