Special Rowno Count- Rest per data group

[#1]

Hello Guys,

Hopefully someone can help me.

I would like to achieve the following in a load script:

Data-set is as follows:

Name

Name1

Name1

Name1

Name2

Name2

Name2

Name3

Name3

Name3

Then load as:

Name,      IDCount

Name1,     1

Name1,     2

Name1,     3

Name2,     1    

Name2,     2

Name2,     3

Name3,     1

Name3,     2

Name3,     3

Name3,     4

I plan on creating a key using Name&IDCount later in the script.

I can do this using a for loop, but I was hoping there would be a neater way of achieving this using a function in the load statement.

Regards,

[Gysbert_Wassenaar · Accepted solution]

Like this:

LOAD

     Name,

     autonumber(RowNo(), Name)) as IDCount

FROM ...

[#3]

Thank you very much for your help Gysbert!!