topic Loading Monthly data into a QVD file in QlikView

Loading Monthly data into a QVD file

Mon, 09 Apr 2012 14:49:39 GMT

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

Re: Loading Monthly data into a QVD file

jagannalla — Mon, 09 Apr 2012 14:56:50 GMT

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..

Re: Loading Monthly data into a QVD file

Mon, 09 Apr 2012 16:57:52 GMT

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