Load field where field contains...

[#1]

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.

[qlikmsg4u · Accepted solution]

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

[Kushal_Chawda]

Load *

From Table

where lower(YourField)='chaine';

[sasiparupudi1]

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

[#5]

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!

[#6]

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

Thank you.

[sasiparupudi1]

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]

Hi Kalyan,

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

Thank you