Incremental Load for excel file

[vikasmahajan]

Dear all,

I have excel file containing lacs of records I have stored this into qvd  and then now I am reloading from QVD.

Now I want to apply incremental load for this excel sheet I have date field as PK.

Please share demo or give idea how to do this .

Thanks

Vikas

[sunny_talwar · Accepted solution]

This presents the basic idea:

QVDFile

LOAD *

FROM QVD.qvd;

MaxDate:

LOAD Max(Date) as MaxDate

Resident QVDFile;

LET vMaxDate = Peek('MaxDate');

DROP Table MaxDate;

Concatenate(QVDFile)

LOAD *

FROM Excel

Where Num(Date) > $(vMaxDate);

STORE QVDFile into QVD.qvd (qvd);

HTH

Best,

Sunny

[senpradip007]

Hi Vikas,

If you have date field as PK, take the latest date from QVD and load the data after that max date.

[vikasmahajan]

Thanks

Vikas

[sunny_talwar]

No problem Vikas,

Best,

Sunny