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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qualify and multiple qvd files

Hi

I have montly data stored as individual .qvd files.

If I use

unqualify *;

MyTable:

LOAD * from *.qvd;

all data goes into the table MyTable.

If I use

qualify *;

unqualify '*IDX';

MyTable:

LOAD * from *.qvd;

I get multiple tables named MyTable-1, MyTable-2 etc.

How can I load the data files into the single MyTable table?

Juerg

10 Replies
supix
Contributor
Contributor

Thanks for sharing.

Perhaps

load * from resident temptable;

should be

load * resident temptable;