topic Re: LIKE Operator in LOAD Script in QlikView

LIKE Operator in LOAD Script

bkn — Mon, 01 Dec 2014 23:14:05 GMT

I am trying to filter the List Box with some words inside it and wants to use Variable and also need to use '*'.

WHERE [Chain] LIKE '*(vR1)*'; ---this is working when i use variable. Note: i need to use variable

Thanks in advance.

Re: LIKE Operator in LOAD Script

MarcoWedel — Tue, 02 Dec 2014 00:20:17 GMT

WHERE [Chain] LIKE '*$(vR1)*';

Re: LIKE Operator in LOAD Script

bkn — Tue, 02 Dec 2014 14:57:21 GMT

Actually its not working when i use variable..

WHERE [Chain] LIKE '*$(vR1)*';

Re: LIKE Operator in LOAD Script

its_anandrjs — Tue, 02 Dec 2014 15:06:30 GMT

Hi,

It is working in any list box expression properties write

This are example

Ex:-

1. Let vR1 = 'T';

=if([Chain] LIKE '*$(vR1)*',[Chain])

Or in the load script it will be

2. In any load script

Raw:

LOAD * Inline [

Chain

BTT

dddTjh

R ];

Let vR1 = 'T';

NoConcatenate

LOAD * Resident Raw Where Chain LIKE '*$(vR1)*';

DROP Table Raw;

Regards

Anand

Re: LIKE Operator in LOAD Script

bkn — Tue, 02 Dec 2014 15:23:52 GMT

Hi Anand, Thanks for quick response. When variable vR1 is string, its working fine. But i need to pick the certain name from the list(column) and put it in variable and use that variable to Where clause.

Re: LIKE Operator in LOAD Script

PrashantSangle — Tue, 02 Dec 2014 15:29:57 GMT

Hi,

You can do one thing .

When you are creating variable that time use * to concat it

like your variable like

Let vR1 = '*Name*';

Regards

Re: LIKE Operator in LOAD Script

its_anandrjs — Tue, 02 Dec 2014 15:31:49 GMT

Definitely it will work try to enter the TT string in the variable and load the data

Raw:

LOAD * Inline [

Chain

BTT

dddTjh

R ];

let vR1 = 'TT';

NoConcatenate

LOAD * Resident Raw Where Chain LIKE '*$(vR1)*';

DROP Table Raw;

Re: LIKE Operator in LOAD Script

bkn — Tue, 02 Dec 2014 15:39:06 GMT

Yes, this works when we use hardcoded value such as TT in variable.

My requirement is to get the value in variable from the Table.

Example:

'NTNAME' is a table which has value like Jack,Ryan,Anand,..

I need to put the NTNAME inside that variable and use that variable in WHERE Clause.

Thanks.

Re: LIKE Operator in LOAD Script

Wed, 03 Dec 2014 04:45:17 GMT

Use WildCard function

Re: LIKE Operator in LOAD Script

bkn — Wed, 03 Dec 2014 20:08:31 GMT

Not working when using Variable and in LOAD Script