Discussion board where members can get started with QlikView.
I have table where there is no Last updated date and Sequential ID and i want to perform incremental load .
How can i do that?
Please share the complete scenario and Sample data
In order to implement Incremental load there should be some unique identifier to identify the new entries, it can be date fields or serial id or even primary keys.
You can look in to the logic of hash keys as well.
If we don't have a ID and timestamp field, we need to generate in our script.
AUTONUMBER(RowNo() & '-' & Field1 & '_' & Field2 & '_' & Field3 & '_' & Field4 & '_' & Field5 & '_' & Field6) as %Key_TaskFact //ID for incremental load
(ooxml, embedded labels, table is sample);
//'03/01/2018' as Start, //For Mastercalendar
'28/12/2017' as Start, //For Mastercalendar
Date(Today(),'DD/MM/YYYY') as End //For Master Calendar
//Date('28/12/2025','DD/MM/YYYY') as End //For Master Calendar
Drop Table Temp;
Date(Start+IterNo()-1,'DD/MM/YYYY') as Date
Resident SR_Temp1 while Start+IterNo()-1 <= End;
Drop Table Temp1;
Store Fact into SR_Fact.qvd;
Drop Table SR_Fact;
What is the table "SR_Temp1" ? because you don't have this table before..
Sorry for my english, I'm french.