Repete record ID "n" times

[Achille123]

Hello, 

I'd like to have a very simple information.

I would like to create a record ID but instead of having a sequence of 1,2,3,4,etc.

I want 1,1,2,2,3,3,4,4, etc.

How can I achieve this?

Thank you

[IraWatt]

Hey @Achille123,

Probably a lot of ways to do this but I'd think the simplest is just to create the record ID's twise then union it back together:

HTH,

Ira

[JarekSkudrzyk · Accepted solution]

@Achille123 hi, you can add generate rows tool and configure it to stop after 2 repetitions:

[DataNath]

Like @IraWatt said, there are multiple ways to do this! Multi-row option attached.