Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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
Thanks.. It really helped.. I used joins