Help required in using LIKE Operator with WHERE condition!

[#1]

Hi

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:
LOAD
Path, 
.
.
.
.
FROM

(qvd)
Where Path LIKE 'c:\apps\product%';

Thanks

Attitude

[gussfish]

Hi,

QlikView isn't SQL! The wildcards that QlikView's LIKE operator

supports are * (for any number of characters) and ? (for exactly single

character).

Angus.

[Miguel_Angel_Baeyens]

Hello,

You can use it with the asterisk

Table:
LOAD F1
FROM Table.qvd (qvd)
WHERE F1 LIKE 'AA*';

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#4]

Hi All

I think the use of WILDMATCH will do the trick. I guess it is working! Yet to test it... 🙂

Log:
LOAD
Path, 
.
.
.
.
FROM

(qvd)
Where WILDMATCH(Path,'*c:\apps\product*');

Thanks

Attitude

[Miguel_Angel_Baeyens]

Hi,

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.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#6]

Thanks Miguel

Your trick has done the trick! If you have free time could you please suggest something for me in the below post.

http://community.qlik.com/message/125391#125391

Regards

Attitude

Message was edited by: At titude. Replaced the link which was wrong before