use loop to perform incremental load

[vireshkolagimat]

Hi All,

I have sales information as per the attachment. I need to get the latest InvDate for each store and then do the incremental load.

Kindly have a look at the file and suggest me how can we achieve using loops.

Regards,

Viresh

[Anil_Babu_Samineni]

Try this first and for increment load we have same future called DML in sql with Qlik

Sample:

LOAD InvDate,

     store,

     InvAmt,

     discount

FROM

[loop demo.xlsx]

(ooxml, embedded labels, table is Sheet1);

Right Join (Sample)

LOAD store, Max(InvDate) as InvDate Resident Sample Group By store;

For Incremental Load, Link below (Not sure which load you are going to have - May be business needed)

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