Can I save the out-put in one excel but in different sheets

[pra_kale]

Hi,

I have below given code which saved the files with a combination of Year and Channel name. Whether it is possible rather than creating a different different excel sheets can i saved all the out puts in single excel file but in different different sheets through script only.

I am attaching the application as well as supporting excel.

Can any one help me in this to modify the script.

Thanks in advance.

A:

LOAD Policy_no,

     Premium,

     Year,

     Month,

     Channel

FROM

(ooxml, embedded labels, table is Sheet1);

for i=1 to FieldValueCount('Channel')

let vChannel = FieldValue('Channel',$(i));

New:

NoConcatenate

LOAD '$(vChannel)' as Channel,

     Policy_no,

     Premium,

     Year as YEAR,

     Month

Resident A

where Channel='$(vChannel)';

for j=1 to FieldValueCount('YEAR')

let vYear = FieldValue('YEAR',$(j));

Final:

NoConcatenate

LOAD *

Resident New

where YEAR='$(vYear)';

STORE Final into E:\Qlikview\$(vChannel)_$(vYear).csv (txt);

DROP Table Final;

NEXT j

DROP Table New;

NEXT i

EXIT Script

[Kushal_Chawda · Accepted solution]

I think this can be done by macro only..

[pra_kale]

Ok...Thanks.

[trdandamudi]

You have to use macros,,,

[pra_kale]

Ok. thanks..