Incremental Load from Excel File

[gayatri7]

Hi All,

I am trying to do incremental load from excel. I have below table for example. Initial Load, I have data till 15-Jan'17. Highlighted records have been added later. How do I merge the new record? I have created a sample logic for the same. But it seems its not working. Please advise!!!

[vinieme12]

hope you are using a field that is a combination of ProductID& Date

[gayatri7]

are you getting any record s in Incremental.qvd. As I was not getting any record.

[qlikview979]

Yes,I am getting data

[qlikview979]

Hi Gayatri,

Follow this steps  This is help full to you

First Paste added records in separate sheet  what you highlighted in Yellow color.

1) Load the Excel in qlikview , then go for reload ,you will get dates from Aug-15 to Jan-17.

2) Next Create QVD and reload Once again, check the qvd path its stored or not.Once stored the QVD.

Sales:

LOAD [Product ID],

    Item,

    Sales,

    [Store Name],

    [Date Modified]

FROM

(ooxml, embedded labels, table is Sheet1);

store Sales into Incremental.qvd;

3) Take max date from date column by using

3)

RecentUpdate:

Load

DAte(Max([Date Modified]) )as MaximumDate

Resident Sales;

4) Create Variable like

Let vLastUpdatedDate= Date(Peek('MaximumDate', 0, Sales));

Drop table Sales;

  Then go for reload  , now variable will show highest date  (15-Jan17)

5) Now past the  yellow color  data in same sheet .

6)Load the Table once again then Write the Where statement like below

IncrementalSales:

LOAD [Product ID],

    Item,

    Sales,

    [Store Name],

    [Date Modified]

FROM

(ooxml, embedded labels, table is Sheet1)

where ([Date Modified])> $(vLastUpdatedDate);

Concatenate(IncrementalSales)

LOAD [Product ID],

    Item,

    Sales,

    [Store Name],

    [Date Modified]

FROM

Incremental.qvd;

7) Over ride the  above stored qvd like this

store IncrementalSales into Incremental.qvd;

Regards

Mahesh