topic Re: Load field where field contains... in QlikView

Load field where field contains...

Mon, 27 Jul 2015 09:44:27 GMT

Hello every one,

I have a field that I want to load in Qlikview. My aim is to load only values that containt a string chaine. How can I do this in the load script.
Many thanks !

Best regards,

Yasser.

Re: Load field where field contains...

qlikmsg4u — Mon, 27 Jul 2015 09:46:56 GMT

load * from source where wildmatch(fieldName,'chaine')

Re: Load field where field contains...

Kushal_Chawda — Mon, 27 Jul 2015 09:47:42 GMT

Load *

From Table

where lower(YourField)='chaine';

Re: Load field where field contains...

sasiparupudi1 — Mon, 27 Jul 2015 09:49:01 GMT

if (index(yourfield,'chaine')>0,yourfield,'')

Re: Load field where field contains...

Mon, 27 Jul 2015 09:56:03 GMT

I worked, but I had to add a * to say it contains. This is the script i used:
load * from source where wildmatch(fieldName,'chaine*')

Many thanks!

Re: Load field where field contains...

Mon, 27 Jul 2015 09:56:50 GMT

I didn't understand this script, can you please explain it to me.

Thank you.

Re: Load field where field contains...

sasiparupudi1 — Mon, 27 Jul 2015 10:03:55 GMT

Index function returns the Position of a substring.

In your case, if index function returns any number greater than 0 then it means that the fild value contains the key word .

hope this helps

Re: Load field where field contains...

bouderbc — Wed, 27 Sep 2017 15:54:30 GMT

Hi Kalyan,

we put the where before the from or inside the from ?

Thank you