Special Rowno Count- Rest per data group

Fri, 09 Oct 2015 08:32:15 GMT

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

Name2

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,

Re: Special Rowno Count- Rest per data group

Gysbert_Wassenaar — Fri, 09 Oct 2015 14:45:43 GMT

Like this:

LOAD

Name,

autonumber(RowNo(), Name)) as IDCount

FROM ...

Sat, 10 Oct 2015 20:49:58 GMT

Thank you very much for your help Gysbert!!