Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
daisy1438
Contributor III
Contributor III

how to create single qvd using multiple excel sheets?

Hi

I have 8 excel sheets.in this 8 sheets having 4 months data. Each month 2 excel sheets. Those two excel sheets I am using left join and store into qvd.

jan1:

id ,name

leftjoin(jan1)

load

id,name

store * from jan1 into pathname.qvd

like that we have feb and mar and apr months data .

how to load the total months data at a time and need to create the single qvd using total months.

Thanks.

3 Replies
OmarBenSalem

Create one table in qlik that'll contain all of ur months (using join or concatenate; depends on ur data).

One this table created, store it into a QVD.

A qvd could store only ONE QLIK TABLE

undergrinder
Specialist II
Specialist II

Hi Daisy,

You can add the other months manually, or create a loop if the number of files dynamically growing.

So:

jan:

noconcatenate

Load

     [columns]

From [excel];

Left join(jan)

Load

     [column]

From [excel];

and so on with the other months, then:

Months:

noconcatenate

Load * from jan;

Load * from feb;

....

drop table jan, feb....;

Keep in mind tables with same columns will concatenated into one, If you have proper key for month as well this not cause any problem at the joining, If not prevent concatenate before the join. So Load -> Join -> Concatenate into one table then you can store.

For the solution with loops I suggest you to read through this thread:

https://community.qlikview.com/thread/217365

G.

praveenkumar_ma
Partner - Creator
Partner - Creator

Hi Daisy ,

Is the excels for different months having same columns.

if so

Load * from the path which have ur 8 files it willload all the files and store it in to one QVD.

it might helps this kind of option is there

hope this might helps

Regards

PM