how to add a Sequential line number to each line in invoice

[davyqliks]

I am loading data from 2 sources, one is historic data with only line number and new daily files with Invoice number and an invoice line number.

I am receiving the same data in both files on some occasions and need to make the Historic have unique lines so i can load with no duplication.

I would like to add a sequential number to the historic load and have found this:

AutoNumber([Invoice no.]) as SeqNo,

but this adds a 1 to each line in a line number e.g.

Invoice no   seqNo

123                 1

123                 1

123                 1

123                 1

124                  2

124                  2

124                  2

etc..

But i require

123        1

123        2

123       3

123       4

124       1

124       2

124      3

Is there a way of achieving this in the load?

Thank you in advance for any offerings on this.

Daniel

[Taoufiq_Zarra]

Hi,

Maye be RowNo()

[Kushal_Chawda · Accepted solution]

you need to use autonumber like below

autonumber(RowNo(),[Invoice Number]) as Seq

[davyqliks]

Hey Kush,

Works a treat... Thank you so much.

Daniel