topic Re: Help required in using LIKE Operator with WHERE condition! in QlikView

Help required in using LIKE Operator with WHERE condition!

Fri, 17 Jun 2011 06:26:35 GMT

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

Re: Help required in using LIKE Operator with WHERE condition!

gussfish — Fri, 17 Jun 2011 06:33:24 GMT

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.

Re: Help required in using LIKE Operator with WHERE condition!

Miguel_Angel_Baeyens — Fri, 17 Jun 2011 06:38:13 GMT

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

Re: Help required in using LIKE Operator with WHERE condition!

Fri, 17 Jun 2011 06:39:48 GMT

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

Re: Help required in using LIKE Operator with WHERE condition!

Miguel_Angel_Baeyens — Fri, 17 Jun 2011 06:47:19 GMT

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

Re: Help required in using LIKE Operator with WHERE condition!

Sat, 18 Jun 2011 06:25:46 GMT

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