How to generate sequence number per change in a given field?

[#1]

Hi all,

I have this problem.

I have a logical table in my application.

I want to generate Line_Number(seqNo) for each distinct value of Field "Doc_No".

So for example I want the Line_Number be generated like this:

Doc_No	Line_Number
K1000	10000
K1000	20000
K1000	30000
K1001	10000
K1001	20000
K1002	10000
K1002	20000
K1002	30000
K1002	40000
K1002	50000

Thanks in advance,

Kari

[lironbaram · Accepted solution]

hi

check the attach file

hope it helps you

[#3]

Thanks,

works excellently.

[#4]

Thanks! Was looking for this too!

[#5]

Liron, I am unable to open the TEST.qvw file since I am running personal edition and I am out of recovery keys.

Anyhow hoping that you could post and explain your script here.

Any assistance would be appriciated

Thanks!

[MayilVahanan]

Hi

Try like this

Load *, if(Previous(Doc_No)=Doc_No,numsum(peek('Line_Number'),1),1) As Line_Number from tableName;

Hope it helps