Add extra column during load which increments by date and transaction for each customer

Wed, 03 Jun 2009 17:13:42 GMT

I have a QV db with a simple transaction table:

CustomerID OrderDate Description Value

A 1/1/2009 ItemA £10

A 2/1/2009 ItemB £15

A 3/1/2009 ItemC £20

B 1/1/2009 ItemX £20

B 5/1/2009 ItemY £15

B 8/1/2009 ItemZ £10

I want to add an extra column during load which identifies the sequential order by date for each customer,

so I can easily identify all first orders, all second orders, max no of orders etc etc e.g.:

CustomerID OrderDate Description Value OrderSeq

A 1/1/2009 ItemA £10 1

A 2/1/2009 ItemB £15 2

A 3/1/2009 ItemC £20 3

B 1/1/2009 ItemX £20 1

B 5/1/2009 ItemY £15 2

B 8/1/2009 ItemZ £10 3

Any ideas?

Thanks

Thu, 04 Jun 2009 16:41:37 GMT

Hi,

see the attached example.

QlikViews "Peek" function helps a lot in cases like this.

Rainer

Wed, 10 Jun 2009 15:51:14 GMT

Thanks Rainer

Works a treat

topic Add extra column during load which increments by date and transaction for each customer in QlikView