Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

sanjyotpatkar
Contributor III

Creation of Single QVD file?

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 ?

1 Solution

Accepted Solutions
mahamedfaijan
Contributor II

Re: Creation of Single QVD file?

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

View solution in original post

3 Replies

Re: Creation of Single QVD file?

mahamedfaijan
Contributor II

Re: Creation of Single QVD file?

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

View solution in original post

sanjyotpatkar
Contributor III

Re: Creation of Single QVD file?

Thanks.. It really helped..  I used joins