Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Loading Monthly data into a QVD file

Monthly accounts are produced in monthly excel spreadsheets, e.g. Jan 2012.xlsx, Feb 2012.xlsx etc.

I need to load these into a single QVD file as new monthly spreadsheets become available so that data for each month is accumulated in the QVD The spreadsheets don't a field that would indicate whether records have been deleted, amended etc.

If anyone can offer any advice I'd really appreciate it.

Tony

Tags (3)
2 Replies
jagannalla
Not applicable

Re: Loading Monthly data into a QVD file

Set vDataPath=D:\QlikView_Data;

Table:

LOAD *,

   *

FROM

$(vDataPath)*.txt

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

STORE Table into Table.qvd;

hope it helps you..

Not applicable

Re: Loading Monthly data into a QVD file

Thanks for the reply.

I can't test just now but will later.

When I store say Feb.xlsx into a QVD, will that not overwrite the Jan. data in the QVD?

Thanks

Tony