Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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