topic load incremetal in QlikView

load incremetal

Wed, 25 Nov 2020 16:16:04 GMT

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 !!!!

Re: load incremetal

kaushiknsolanki — Thu, 31 Aug 2017 13:55:47 GMT

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

Re: load incremetal

ramasaisaksoft — Thu, 31 Aug 2017 14:48:06 GMT

Hi Cao,

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

Re: load incremetal

Fri, 01 Sep 2017 02:45:20 GMT

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,

Re: load incremetal

Fri, 01 Sep 2017 04:14:02 GMT

hi,

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

Pls give me more ideal .