I need to mark each duplicate record in load script with an incremental number.
1 , 1
and so on.
Try something like this:
1 As Mark
If(InvoiceID = Previous(InvoiceID), Peek('Mark') + 1, Mark) As Mark
Order By InvoiceID;
You may need to also sort by a datetime value to mark the invoices correctly.
View solution in original post