topic Re: Incremental Load Query in QlikView

Incremental Load Query

Fri, 14 Nov 2014 10:36:52 GMT

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 ?

Re: Incremental Load Query

Gysbert_Wassenaar — Fri, 14 Nov 2014 10:48:16 GMT

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;

Re: Incremental Load Query

Fri, 14 Nov 2014 11:33:34 GMT

will incremental load work with alphanumeric

Re: Incremental Load Query

Fri, 14 Nov 2014 11:55:31 GMT

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

Re: Incremental Load Query

Gysbert_Wassenaar — Fri, 14 Nov 2014 12:10:41 GMT

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/

Re: Incremental Load Query

jonathandienst — Fri, 14 Nov 2014 12:26:52 GMT

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, ...)

Re: Incremental Load Query

Mon, 17 Nov 2014 09:01:13 GMT

Thanks Gysbert It worked

Re: Incremental Load Query

Mon, 17 Nov 2014 09:03:29 GMT

Thanks Jonathan