Discussion Board for collaboration on QlikView Scripting.
I'm loading rows from csv
How can I filter the rows during load so that the text field has to have certain value?
@3 LIKE '%foo%'
@3 = '*foo*'
But can't figure out the right syntax. Thanks for any help on this.
Go to Solution.
it seems that you are quite close, try this:
. . .
WHERE(@1 like '*foo*');