Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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