Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 - Specialist III
Partner - Specialist III

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
Author

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