Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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

View solution in original post

7 Replies
qlikmsg4u
Specialist
Specialist

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

Kushal_Chawda

Load *

From Table

where lower(YourField)='chaine';

sasiparupudi1
Master III
Master III

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

Not applicable
Author

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
Author

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

Thank you.

sasiparupudi1
Master III
Master III

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
Creator
Creator

Hi Kalyan,

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

Thank you