Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Help required in using LIKE Operator with WHERE condition!

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

5 Replies
gussfish
Not applicable

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

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
Not applicable

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

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

Not applicable

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

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
Not applicable

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

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

Not applicable

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

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