Creation of Single QVD file?

[Anonymous]

Hi

I am loading multiple excel files in one QV file. Is it possible to create a single qvd file instead of multiple qvd file for each file that i read ?

[Kushal_Chawda]

see this

Dynamically Loading Multiple Excel Files

[Mahamed_Qlik · Accepted solution]

Hi Sanjyot,

Yes, it is possible to create single qvd rather than creating qvd for each excel file.

You can do it in following ways :

- Load your excel file into the qlikview script editor (For example excel1.xls) and provide the table name as suppose T       Table1

- Now load another excel file (excel2.xls)

- now, you can use either concatenate to Table1 or if there is key relation between the excel files and u need only matching records then you can use joins in between excel load. ( For this you can refer joins concept in community)

-Finally you will have single table with all the excel data into it and now you can store it into the single qvd file.

Hope it is helpful.

Regards,

Mahamed

[Anonymous]

Thanks.. It really helped..  I used joins