Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

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

Generate duplicate row for each column containing data

MB31
5 - Atom

Hi, All

I am pretty new to Alteryx and am looking for a way to generate duplicate rows for each column that has data in it as well as move the column data to the newly created row. I did see the Generate Rows tool, but unfortunately it seems complicated when non-numerical data is used.

 

Any help/advice would be appreciated

 

Sample data

TaskPreparerReviewer 1Reviewer 2Reviewer 3
Task 1Person APerson BPerson CPerson D

 

Desired result

Task

Name
Task 1Person A
Task 1Person B
Task 1Person C
Task 1Person D
2 REPLIES 2
ZacharyM
Alteryx Alumni (Retired)

The generate rows tool is used to add rows to data of the same structure (think 'fill in the data') - in your case, you want to re-structure the data, so a few steps are likely required.

 

I expanded on your example data a bit to make sure that my solution would capture not just your sample, but the full use case.

 

Please let me know if I missed something - if this solves your issue, please mark this as an accepted solution so people know you've been helped :)

 

Cheers!

Zak

DavidP
17 - Castor
17 - Castor

The Transpose tool will do this for you if you group on Task

 

transpose.png