use a variable in Wildmatch

Fri, 30 Dec 2011 09:51:02 GMT

Gents,

I want to create an index that I can use as a manner of search/lookup on user defined arguments...

The result now is a table with all arguments times number of records (to be looked up)... so everything is selected which is wrong.

Can anyone help me with this one?

Thx in advance

try to implement the following code in my script:

Temp:
load
max(#Nr) as maxrec
resident Argument;

let vMaxrec = num(peek('maxrec',0,'Temp'));
drop table Temp;

Set vSearch = peek('Argument', $(i)-1,'Argument');

FOR i = 1 to $(vMaxrec) // read arguments per record number from arguments table and create index
Arg_Indx:

LOAD Order_nmbr,

if(WildMatch(Order_Description,'*'&$(vSearch)&'*'), $(i), 99999) as #Nr

resident Orders
;
NEXT i
//

SunilChauhan — Fri, 30 Dec 2011 10:07:25 GMT

keep

Set vSearch = peek('Argument', $(i)-1,'Argument');

after for loop

hope this helps

Fri, 30 Dec 2011 10:28:47 GMT

Hi Sunil,

thx!!

Works fine now....

Regards

topic use a variable in Wildmatch in QlikView