Generate Rows newbie question

Hi, I have been using Alteryx for a week now and this is my first post here. This may be a relatively easy question but I couldn't solve it myself.

I'm trying to create two columns, with 10,000 rows:

- The first column goes from 1 to 100, with each number repeating itself 100 times.

- The second column has a sequence of numbers from 1-100 a hundred times.

Example:

1 1

1 2

1 3

2 1

2 2

2 3

3 1

3 2

3 3

So, instead of 1 to 3, I would like to do it from 1 to 100. I managed to do the second column using generate rows, but I don't know how to do the first one.

Thanks in advance!!

Example 1.yxmd

Preparation

Accepted answers

Laurap1228

Hi Diego,

You were on the right track. Check out the example workflow attached. I added a multi-row formula tool to get 1-100 repeated over and over again Column2. Then sort Cloumn2, rename it Column1 add a RecordID and join back to the original.

Diego workflow.PNG

Hope this helps!

Cheers,

Laura

Example for Diego.yxmd

Claje

Another option for this request is to use two Generate Row tools, each to generate a column with 100 values, in sequence.

I've attached an example of this, using the same template as the initial example.

The generate Rows tool will process for each initial row of data fed into it, so you can easily create recordsets like the one you were looking for.

claje_sequencegeneraterows.yxmd

All comments

Laurap1228

Hi Diego,

Diego workflow.PNG

Hope this helps!

Cheers,

Laura

Example for Diego.yxmd

DiegoParker

Thank you Laura! This is great, exactly what I was looking for. Because it has been just two weeks at the school, I'm struggling to understand fully what the first formula is doing. Would you mind explaining me? thank you a lot

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703