Defining SET is not working in For each loop??

[#1]

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

[maxgro · Accepted solution]

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)');

next

[#3]

Worked like charm . Thank you