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
20 - Arcturus
20 - Arcturus

@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
20 - Arcturus
20 - Arcturus

@LeiCheng 
Glad to be any help.

Labels