incremental data update in qlik sense

[mert1917]

Hi Everyone,

I need your help about incrementel data update.

Can you help me please?

question;

1.EXECUTEDATE:01.01.2020;

ID_1	ID_2	STATUS	DATE
1	34	A	1.01.2020
2	35	B	1.01.2020
3	36	C	1.01.2020
4	37	D	1.01.2020

2.EXECUTEDATE:02.01.2020;

ID_1	ID_2	STATUS	DATE
5	34	B	2.01.2020
6	35	U	2.01.2020
7	38	A	2.01.2020
8	39	B	2.01.2020

After my target incremental table;

(FINAL TABLE)

ID_1	ID_2	STATUS	DATE
1	34	B	1.01.2020
2	35	U	1.01.2020
3	36	C	1.01.2020
4	37	D	1.01.2020
5	34	B	2.01.2020
6	35	U	2.01.2020
7	38	A	2.01.2020
8	39	B	2.01.2020

How can I do that?
What is the script?

Best regards

[lawrance]

Hi,

Please refer this below url. I hope this will helps to answer your question.

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/LoadData/use-QVD-fil...

[Vegar]

It feels like you left out some information (maybe you simplified your source data to much). 
With the current description the solution I'll give it a shot. Try this.

If QvdCreateTime('File.qvd')>0
  Data:
  Load ID_1, ID_2, STATUS, DATE
  From File.qvd (qvd);
Endif

//Autoconcatenate
Data:
Load ID_1, ID_2, STATUS, DATE 
From Source
Where not exsists (ID_1);

Store Data Into File.qvd (qvd);
Drop table Data;

[mert1917]

Hi,

thank you for yor help
I will examine this url.

regards 

[mert1917]

Hi all,

I couldn't solve the problem.

how can i solve?

Can you help me plase?

MAXKEYLOAD : load max(date(DATE,'DD.MM.YYYY')) as MAXID FROM (QVD);

LET MAXID= PEEK('MAXID',0,MAXKEYLOAD);

INC :  LOAD ID_1,ID_2,STATUS,DATE FROM (DATA) WHERE DATE>'$(MAXID)';

Concatenate

LOAD*FROM (QVD) WHERE not EXISTS(ID_1);

Inner Join

LOAD ID_1,ID_2,STATUS,DATE FROM (DATA);

If ScriptErrorCount =0 then

Store INC into (QVD);

End If

[Vegar]

Where lies you issue? Please explain. 

[mert1917]

hi,
I think my script is wrong, this table does not appear and I cannot find the error.

How will i do ?

(FINAL TABLE)

ID_1	ID_2	STATUS	DATE
1	34	B	1.01.2020
2	35	U	1.01.2020
3	36	C	1.01.2020
4	37	D	1.01.2020
5	34	B	2.01.2020
6	35	U	2.01.2020
7	38	A	2.01.2020
8	39	B	2.01.2020

[Brett_Bleess]

Your best bet at this point is to be sure you have the Script/Document log enabled, so you can see exactly what is going on during the reload process as to what calls are being made and how many rows are returned etc...

How to enable the script log

Only other thing I could offer would be to maybe use the Debugger in the Script Editor to try to see what is going on via limited number of rows stepping through things.

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

Regards,
Brett