Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Please refer this below url. I hope this will helps to answer your question.
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;
Hi,
thank you for yor help
I will examine this url.
regards
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
Where lies you issue? Please explain.
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 |
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...
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