Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
@jamelmessaoud Perhaps this
AutoNumber(Order, IterNo()) as AuthNo
On which field should your auto number field be based? Usually you only have to use the function AutoNumber() on that field.
@jamelmessaoud Perhaps this
AutoNumber(Order, IterNo()) as AuthNo
This has only gone and worked!!
Thanks so much Anil 😀