Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you need to use autonumber like below
autonumber(RowNo(),[Invoice Number]) as Seq
Hi,
Maye be RowNo()
you need to use autonumber like below
autonumber(RowNo(),[Invoice Number]) as Seq
Hey Kush,
Works a treat... Thank you so much.
Daniel