append/accumulate

[#1]

Hi

I'm loading in very simple data from an excel spreadsheet. There are a few more cols and thousand odd rows. Similar to below

A/C	SALES	DATE
7071249113705505	67	07/01/2012
7071249111846228	23	08/01/2012
7071249111846228	9	09/01/2012
7071249111846228	6	01/01/2012
7071249111846228	3	04/01/2012
7071249111846228	45	05/01/2012
7071249111846228	12	06/01/2012
7071249111846228	3	07/01/2012

then I have another spreadsheet that tells me more about the a/c which is all linked via the a/c col

Basically I get data like this every month and I want to load into a QV to do some totals and stuff. How do I set up the script? Do I just manually load in the data each month. Because I have another ss when I load in my new monthly ss I get $Syn tables

Can anyone suggest anything

thanks

[Miguel_Angel_Baeyens]

Hi Melanie,

What you need to use at a first glance is use CONCATENATE that will append the new table to an existing one. Take a look at the following example:

LastMonth:
LOAD AC,
     SALES,
     DATE
FROM August.qvd (qvd);
CurrentMonth:
CONCATENATE (LastMonth) LOAD *
FROM SeptemberFile.xls ...
//At this moment you only have one table: LastMonth that you can store
//into only one QVD with data from both months.

Hope that gives you an idea.

Miguel

[#3]

ok, I thought it was something like that. I'm not at all familiar with concatenate, so will do some research here.

Thanks for a very prompt response