https://community.qlik.com/t5/QlikView/Extract-and-Append-Data-Using-Macros-in-Qlikview/m-p/1509652#M750185 <P>You can achieve the same by using incremental load in script. there is no need for using a macro.</P><P>Your script should look like this:</P><PRE>Historical_Data: LOAD .... FROM [historical.qvd] (qvd); concatenate Actual_Data: LOAD ....... FROM .... store Historical_Data into historical.qvd (qvd);</PRE><P>&nbsp;</P><P>initially you need to generate the historical qvd. and afterwards you can use the above mentioned script syntax.&nbsp;</P> Tue, 20 Nov 2018 11:35:06 GMT Frank_Hartmann 2018-11-20T11:35:06Z https://community.qlik.com/t5/QlikView/Extract-and-Append-Data-Using-Macros-in-Qlikview/m-p/1509643#M750184 <P>Hi All,</P><P>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.</P><P>Please help me on this Macro scripting.</P><P>Thanks.</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Extract-and-Append-Data-Using-Macros-in-Qlikview/m-p/1509643#M750184 sunitha_chellaiah 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Extract-and-Append-Data-Using-Macros-in-Qlikview/m-p/1509652#M750185 <P>You can achieve the same by using incremental load in script. there is no need for using a macro.</P><P>Your script should look like this:</P><PRE>Historical_Data: LOAD .... FROM [historical.qvd] (qvd); concatenate Actual_Data: LOAD ....... FROM .... store Historical_Data into historical.qvd (qvd);</PRE><P>&nbsp;</P><P>initially you need to generate the historical qvd. and afterwards you can use the above mentioned script syntax.&nbsp;</P> Tue, 20 Nov 2018 11:35:06 GMT https://community.qlik.com/t5/QlikView/Extract-and-Append-Data-Using-Macros-in-Qlikview/m-p/1509652#M750185 Frank_Hartmann 2018-11-20T11:35:06Z