Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
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

2 Replies
jagannalla
Partner
Partner

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

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