Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new in Qlikview, i have a case where columns named as Id(Char type and Unique), F_name, L_name, Date_of_Birth. New rows get inserted having random id
What could be filtration criteria for incremental load or column with incremental identification is necessary in source of data
Hi Santhosh,
Do you have the entry added date?
You could make your incremental load based on ReloadTime() function, getting only the records that have dates greater then the ReloadTime() date.
Felipe.
Thanks Felipe
Does the Id field increase for each load? You could use the maximum loaded Id field to filter the incremental load.
LOAD Max(Id) as MaxID FROM Incremental.qvd (qvd);
Let vMaxID = Peek('MaxID');
Data:
SQL
Select Id, .....
Where Id > '$(vMaxID)';
Concatenate (Data)
LOAD * ROM Incremental.qvd (qvd);
If the Id field can't be used like that and there is no updated or created date field, then you will not be able to load this data incrementally.