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.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels