Incremental load without incremental identification column

[Anonymous]

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

[felipedl]

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.

[Anonymous]

Thanks Felipe

[jonathandienst]

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.