WHERE Clause in Load Script using variable

bkn — Tue, 02 Dec 2014 18:57:35 GMT

My requirement is to get the value in variable from the Table and use in WHERE Clause in Load Script.

Example:

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

Variable vR1 stores values from NTNAME.

I need to put the NTNAME inside that variable and use that variable vR1 in WHERE Clause and need to use Wilcard '*'

=IF(WildMatch([Chain],'*$(vR1)*'),[Chain])

Thanks in Advance.

topic WHERE Clause in Load Script using variable in QlikView