Repete record ID "n" times

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

Accepted answers

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

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

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

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