Multiple excel file load to create QVD

[bushpalaamarnat]

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.

[tamilarasu · Accepted solution]

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.

[shiveshsingh]

Hi

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