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

[#1]

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

[#2 · Accepted solution]

Hi,

see the attached example.

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

Rainer

[#3]

Thanks Rainer

Works a treat