Extract and Append Data Using Macros in Qlikview

[sunitha_chellaiah]

Hi All,

I want to extract straight table data in Excel file using Macros in QlikView. And On daily refresh, data should get append to previously extracted excel file.

Please help me on this Macro scripting.

Thanks.

[Frank_Hartmann]

You can achieve the same by using incremental load in script. there is no need for using a macro.

Your script should look like this:

Historical_Data:
LOAD 
....
FROM
[historical.qvd]
(qvd);

concatenate

Actual_Data:
LOAD 
.......
FROM ....

store Historical_Data into historical.qvd (qvd);

initially you need to generate the historical qvd. and afterwards you can use the above mentioned script syntax.