I have some data that looks like the following:
My current AutoNumber expression in the script looks like:
AutoNumber(CompanyCode & '-' & YearMonth)
But it gives me a continues numbering like you see in the AutoNumber column example.
What I want to do is get my AutoNumber output to be like NEW AutoNumber column where it restarts after a new CompanyCode even if YearMonth values are similar.
Does anyone know how to do this please?
Solved! Go to Solution.
If you just want to restart the counter in your load script, see this discussion and the example document: Numbering Rows more examples? One of the three methods fits your bill