topic Re: append/accumulate in QlikView

append/accumulate

Fri, 14 Sep 2012 14:38:27 GMT

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

Re: append/accumulate

Miguel_Angel_Baeyens — Fri, 14 Sep 2012 14:42:48 GMT

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

Re: append/accumulate

Fri, 14 Sep 2012 14:45:14 GMT

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