topic Re: incremental data update in qlik sense in QlikView

incremental data update in qlik sense

mert1917 — Sun, 09 Feb 2020 10:08:49 GMT

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

Re: incremental data update in qlik sense

lawrance — Sun, 09 Feb 2020 12:02:36 GMT

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-files-incremental-load.htm

Re: incremental data update in qlik sense

Vegar — Sun, 09 Feb 2020 14:01:21 GMT

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;

Re: incremental data update in qlik sense

mert1917 — Sun, 09 Feb 2020 15:29:24 GMT

Hi,

thank you for yor help
I will examine this url.

regards

Re: incremental data update in qlik sense

mert1917 — Tue, 11 Feb 2020 11:14:17 GMT

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

Re: incremental data update in qlik sense

Vegar — Tue, 11 Feb 2020 14:42:02 GMT

Where lies you issue? Please explain.

Re: incremental data update in qlik sense

mert1917 — Tue, 11 Feb 2020 17:13:56 GMT

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

Re: incremental data update in qlik sense

Brett_Bleess — Thu, 05 Mar 2020 17:43:36 GMT

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