We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to make a specified sequence of numbers repeat in a column of data?

LeiCheng
8 - Asteroid

The number of rows in my table varies every time as I don't know how many rows of my raw data. I want to define a new column with a specified sequence of numbers repeat in it. such as repeat 123 in the new column:

1

2

3

1

2

3

.

.

.

Can  I do this? Thanks.

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@LeiCheng 
If I understand your requirement correctly, we can use generate Row tools to do something like this.

0204-Leicheng.png

LeiCheng
8 - Asteroid

@Qiu   You are amazing, thank you!

Qiu
21 - Polaris
21 - Polaris

@LeiCheng 
Glad to be any help.

Labels
Top Solution Authors