Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Load field where field contains...

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.

1 Solution

Accepted Solutions
qlikmsg4u
Valued Contributor

Re: Load field where field contains...

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

7 Replies
qlikmsg4u
Valued Contributor

Re: Load field where field contains...

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

Re: Load field where field contains...

Load *

From Table

where lower(YourField)='chaine';

sasiparupudi1
Honored Contributor III

Re: Load field where field contains...

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

Not applicable

Re: Load field where field contains...

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!

Not applicable

Re: Load field where field contains...

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

Thank you.

sasiparupudi1
Honored Contributor III

Re: Load field where field contains...

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

bouderbc
New Contributor III

Re: Load field where field contains...

Hi Kalyan,

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

Thank you

Community Browser