topic Re: Multiple excel file load to create QVD in QlikView

Multiple excel file load to create QVD

bushpalaamarnat — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Kindly help, I have attached sample 2 excel files for understanding, the data in the excel files is dynamic is nature, they change every week. every week a new file added into the folder. The objective is to load all the files into a one Qvd and retain the files names as well.

I need to load data and replace any updates with the latest files information.

Could you advise.

Re: Multiple excel file load to create QVD

tamilarasu — Fri, 02 Feb 2018 20:06:59 GMT

Hi Neelima,

You have to use incremental load (insert, update and delete) in this case.

1. Create a qvd for the inital file i.e 19 Jan 18.xls.

2. You can use Filename() as FileName syntax to store the file name in qvd's.

3. Use Material as primary key and week as modified date and then perform incremental load.

Below link will be helpful and easier to understand.

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

Good luck.

Re: Multiple excel file load to create QVD

shiveshsingh — Sat, 03 Feb 2018 02:55:41 GMT

Try this

Table:

LOAD left(FileName(),9) as FILE_NAME,Week, Material,

[Material Description],

[Material Type],

Category,

[Inventory Volume],

[Demand Volume (Eaches)],

Brand, Variant,

[Customer Loc],

[Customer Location Description],

[Customer Zone],

[Supplier Loc],

[Supplier Location Description],

[Supplier Zone],

[Corridor Status],

DFC, [Min DFC],

[Max DFC],

[Safety Days Supply]

FROM [* Jan 18.xlsx]

(ooxml, embedded labels, table is Sheet1);

and for regular update, use concept of incremental load.

I think, this helps