Incremental Load Query

[#1]

I want to apply incremental load in a SAP table named BSEG_ADD ,it don't have primary key field .I have to implement the incremental using composite key.As per SAP team ,they have given me list of fields, which we can use  as primary key.

But the problem is that some of their fields(which i have to use as a primary key), have text value and some include number value.

What do to ?

[Gysbert_Wassenaar]

Simply concatenate the values from the two fields to create a unique field. You can do this in an sql statement or in a Qlikivew load statement:

LOAD *, FieldA & '|' FieldB as Key;

SQL SELECT * FROM BSEG_ADD;

[#3]

will incremental load  work with alphanumeric

or

[#4]

I have already done the same thing , but one of colleague told me that if i am using composite key and it include alpha numeric values it won't work with incremental load or never give the correct result

[Gysbert_Wassenaar · Accepted solution]

Your colleague is wrong. You need a primary key and usually a field that has something like a modification timestamp or a version number. The data type of the primary key is irrelevant. If you only add new records then the primary key alone suffices. Perhaps this blog post helps: http://www.quickintelligence.co.uk/qlikview-incremental-load/

[jonathandienst]

I agree with Gysbert - the data type is largely irrelevant, but incremental loading is much simpler if the key has some ordinal characteristic such as a date, or a row ID that increments. It can be numerically ordinal (1, 2, 3...) or alphanumerically ordinal (A1, A2, B1, C1, C2, ...)

[#7]

Thanks Gysbert It worked

[#8]

Thanks Jonathan