topic Replace Data into Qvd in App Development

Replace Data into Qvd

GOKULAKANNAN — Sat, 16 Oct 2021 16:50:41 GMT

Hi All,

I'm having 4 rows of data like below

Item	country	Modified date	FLAG
1234	India	27-07-2020	0
3456	Canada	28-07-2020	0
5676	USA	30-07-2020	0
7890	Canada	01-08-2020	0

on first reload the above data will be saved in qvd. now the update will be like addition of 2 rows within that one is a new record another one is as same as old record but only modified date will get change(last row)

Item	country	Modified date	flag
1234	India	27-07-2020	0
3456	Canada	28-07-2020	0
5676	USA	30-07-2020	0
7890	Canada	01-08-2020	0
9876	Sweden	01-09-2020	0
1234	India	28-07-2020	1

Now in the last row the record is same , only change is modified date, in this case if we do concatenate it will add all the rows and it will save it in qvd, but I want to delete the existing record and add the new record and save it in qvd. how can I achieve this? I need resultant value to be like below in QVD

Item	country	Modified date	flag
3456	Canada	28-07-2020	0
5676	USA	30-07-2020	0
7890	Canada	01-08-2020	0
9876	Sweden	01-09-2020	0
1234	India	28-07-2020	1

Thanks

Re: Replace Data into Qvd

Thiago_Justen_ — Sun, 17 Oct 2021 04:27:10 GMT

Hi there.

You should use incremental load: Incremental Load Qlik Help

Regards

Re: Replace Data into Qvd

GOKULAKANNAN — Sun, 17 Oct 2021 05:48:43 GMT

Could you please send the code or example..I have tried incremental load but in that am able to get the new records but not able the replace the old one.

Re: Replace Data into Qvd

Thiago_Justen_ — Sun, 17 Oct 2021 06:08:28 GMT

Qli Help has one simple and applicable example:

Let ThisExecTime = Now( );

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

WHERE ModificationTime >= #$(LastExecTime)#

AND ModificationTime < #$(ThisExecTime)#;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD

WHERE NOT EXISTS(PrimaryKey);

Inner Join SQL SELECT PrimaryKey FROM DB_TABLE;

If ScriptErrorCount = 0 then

STORE QV_Table INTO File.QVD;

Let LastExecTime = ThisExecTime;

End If