Auto Number function

[jamelmessaoud]

Hi guys,

I have some data in the format like below

I would like to create the Auto Number in the load script like I have in the screenshot above but I cannot figure it out. 

Can anyone offer any guidance please?

[steeefan]

On which field should your auto number field be based? Usually you only have to use the function AutoNumber() on that field.

[Anil_Babu_Samineni · Accepted solution]

@jamelmessaoud Perhaps this

AutoNumber(Order, IterNo()) as AuthNo

[jamelmessaoud]

This has only gone and worked!!

Thanks so much Anil 😀