Alteryx Designer Discussions

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

Replicate Data

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

 

17 - Castor

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 😀👍

 

17 - Castor

Happy to help 🙂 @tjamal1 

 

Cheers and Happy Analyzing 😀

Labels