Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

append/accumulate

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/CSALESDATE
70712491137055056707/01/2012
70712491118462282308/01/2012
7071249111846228909/01/2012
7071249111846228601/01/2012
7071249111846228304/01/2012
70712491118462284505/01/2012
70712491118462281206/01/2012
70712491118462283

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

2 Replies

Re: append/accumulate

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

Not applicable

Re: append/accumulate

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

Community Browser