load incremetal

[#1]

when i reload data, file qvw up to 80Mb. I save it.

but after 1 week, data is incremetaled, I want reload data, combine old data(data reloaded, file 80Mb) with new data(data in 1week) to save time for reloading , How can I do ?? 

I try by "Load incremetal" of Qlikview tutorial , but time to reload is same.

I need a method to reload which saved time . Pls help me !!!!

[kaushiknsolanki]

Hi,

Make sure you use proper date field to know what records are new or updated.

Check below link.

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

Incremental Load in Qlikview - Sources

Regards,

Kaushik Solanki

[ramasaisaksoft]

Hi Cao,

if possible please share your code which u applied incremental  concept so that we will give guide lines where you did mistake.

[#4]

hi Rama,

my code :

SET vQvdFile='C:\QVD\Sales.qvd'; // in local

SET vTableName='Fact_SalesDetail';

LET vQvdExists = if(FileSize('$(vQvdFile)') > 0, -1, 0);

IF $(vQvdExists) THEN

maxdateTab:

LOAD Date(max("TS"),'YYYY-MM-DD') as maxdate

FROM $(vQvdFile) (qvd);

//LET vIncrementalExpression = 'Where ("TS") >=' & Chr(39) & peek('maxdate') & Chr(39);

Let  vMax = peek('maxdate',0,'maxdateTab');

DROP table maxdateTab;

Fact_SalesDetail:

LOAD

   DBILLDATE,

   YEAR(DBILLDATE) AS YEAR,

   MONTH(DBILLDATE) AS MONTH,

   CRECEIPTTYPE,TS

FROM Fact_Sales.qvd  //in server

(qvd)  Where TS > $(vMax) ;

IF $(vQvdExists) THEN

CONCATENATE ($(vTableName))

LOAD * FROM $(vQvdFile) (qvd)

WHERE NOT exists("TS");

End IF

STORE Fact_SalesDetail into C:\QVD\Sales.qvd(qvd);

Thanks,

[#5]

hi,

I saw all those . It's same with my code. And it don't save time for reloading .

Pls give me more ideal .