Incremental reload with a Composite Key as primary Key

Tue, 15 Jun 2010 13:32:55 GMT

Hi All,

Greetings!!!

I need a script for incremental reload for Insert, Update and delete where we dont have single primary Key. Id I make a composite key with 4 fields then only It become primary Key.

Ex.

Load

Last_Updated_Date

from TAB1.csv;

Here The composite key of A,B,C is primary key.

Please provide me the script.

Thanks in Advance.

Regards,

Veman Reddy

Incremental reload with a Composite Key as primary Key

sparur — Tue, 15 Jun 2010 13:40:25 GMT

Hello, Verman

see an example of Incremenal Reload in http://robwunderlich.com/downloads/cookbook_V009.1.zip

Rob created a good example.

with composite primary key (A &'~'& B &'~'& C AS PrimaryKey) this approach is working too.

topic Incremental reload with a Composite Key as primary Key in QlikView

Incremental reload with a Composite Key as primary Key

Incremental reload with a Composite Key as primary Key