Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

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

Replicate Data

tjamal1
8 - Asteroid

Hello,

I have a data set that contains these records.

I wanted to replicate Sign UP Channel and SignUpStatus till the 46th period to generate more rows. How can I do this in the Alteryx Designer?

PeriodSignUpChannelSignUpStatus
1AActive
1APending
1AInactive
1BActive
1BPending
1BInactive
1CActive
1CPending
1CInactive

 

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @tjamal1 

 

Here is a workflow for the task.

Output:

atcodedog05_0-1603823979989.png

atcodedog05_0-1603824067894.png

 

till 46 for each combination.

Workflow:

atcodedog05_1-1603823992328.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

 

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @tjamal1 

 

Cheers and Happy Analyzing 😀

Labels
Top Solution Authors