topic Defining SET is not working in For each loop?? in QlikView

Defining SET is not working in For each loop??

Sat, 13 Sep 2014 14:48:13 GMT

Hi,

I have script like this and it is working fine, but when I use set like this SET i='A-01','B-01','C-01'; I understand that if I use - it is not working, but when I remove - it works fine. I don't want to change the 'A-01' as my source file is coming like that, so don't want to modify that, Is qlikview behaves like or is there any alternative solution.

SET i = 'A','B','C';
// SET i = 'A-01','B-01','C-01'; NOT WORKING
for each m in $(i);
LOAD [Sr No],
      [Prod ID],
      [Prod Name],
      Month
FROM
D:\Project\Testing.xlsx
(ooxml, embedded labels, table is $(m));
next

Re: Defining SET is not working in For each loop??

maxgro — Sat, 13 Sep 2014 14:58:01 GMT

add quotes

//SET i = 'A','B','C';

SET i = 'A-01','B-01','C-01'; //NOT WORKING

for each m in $(i);

LOAD

//[Sr No],

// [Prod ID],

// [Prod Name],

// Month

FROM

a.xlsx

(ooxml, embedded labels, table is '$(m)');

Re: Defining SET is not working in For each loop??

Sat, 13 Sep 2014 15:07:32 GMT

Worked like charm . Thank you