use loop to perform incremental load

vireshkolagimat — Tue, 28 Nov 2017 19:11:44 GMT

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

Re: use loop to perform incremental load

Anil_Babu_Samineni — Wed, 29 Nov 2017 01:49:23 GMT

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)