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 !
load * from source where wildmatch(fieldName,'chaine')
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*')
I didn't understand this script, can you please explain it to me.
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
Retrieving data ...