Discussion board where members can get started with QlikView.
How to use the LIKE Operator with Where condition while loading data from QVD. I tried something like below but it is not returning any rows. Please help me out!
Log:LOADPath, ....FROM(qvd)Where Path LIKE 'c:\apps\product%';
LOADPath, ....FROM(qvd)Where Path LIKE 'c:\apps\product%';
QlikView isn't SQL! The wildcards that QlikView's LIKE operator
supports are * (for any number of characters) and ? (for exactly single
You can use it with the asterisk
Table:LOAD F1FROM Table.qvd (qvd)WHERE F1 LIKE 'AA*';
FROM Table.qvd (qvd)
WHERE F1 LIKE 'AA*';
Hope that helps.
Miguel Angel Baeyens
Comex Grupo Ibérica
I think the use of WILDMATCH will do the trick. I guess it is working! Yet to test it... :-)
Log:LOADPath, ....FROM(qvd)Where WILDMATCH(Path,'*c:\apps\product*');
Yes, that will work. Anyway, WildMatch is used when you need to compare to multiple values (very similar to the IN clause in SQL). If you only need one value, LIKE will do.
Your trick has done the trick! If you have free time could you please suggest something for me in the below post.
Message was edited by: At titude. Replaced the link which was wrong before