incremental tables script explain.

[riishabhz]

hi can any one please explain me the difference between two scripts :-

first script:-

"NonTest":

LOAD *

FROM

C:\Test\Qvd\NonTest.qvd(qvd);

catenate (NonTest)

SQL select *

FROM "62_DW".dbo."t_test"

where  Date>$(vMaxDate);

STORE "NonTest" INTO '$(vDataQvds)NonTest.qvd' (qvd);

DROP TABLE NonTest;

2nd script :-

"NonTest":

SQL select *

FROM "62_DW".dbo."t_test"

where Date>$(vMaxDate);

Temp:

load max (Date) as MaxDate

resident NonTest;

let vMaxDate=peek('MaxDate');

drop table Temp;

Concatenate (NonTest)

LOAD *

FROM

C:\Test\Qvd\NonTest.qvd(qvd);

STORE "NonTest" INTO '$(vDataQvds)NonTest.qvd' (qvd);

DROP TABLE NonTest;

which script will work for incremental load , please tell me.

[riishabhz]

Ok sir i will update you in 12hrs

[Brett_Bleess]

Not sure if you are still working on things or not, but I wanted to give you a couple of links just in case you had not found them:

https://community.qlik.com/t5/Qlik-Design-Blog/Overview-of-Qlik-Incremental-Loading/ba-p/1466780

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/QVD_Incremental...

Hopefully those may help if you are still struggling to understand things.  Do not feel badly, this area is quite tricky to get a handle upon as well, just keep trying, and I am confident you will get it sorted out, and it will likely make more sense at that point too.  Shout if you have more questions, hopefully one of us can try to come up with some further info for you in that case.

Regards,
Brett