ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Designer Discussions

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

Move some columns to rows

G_WOLAK
7 - Meteor

Apologies as I cannot quite figure out how to title this question. 

 

I have a data set where I need to duplicate some of the rows and carry over only some of the data in the columns.  In the picture below the top rows represents how the data is now.  The bottom rows is how I would like the data to look after modifying it. 

 

Also attaching the sample file if it helps.

 

I figured I might have to use some of the transform tools or the join tools, but haven't gotten the desired results.

 

G_WOLAK_0-1581089272180.png

CharlieS
17 - Castor
17 - Castor

Hi @G_WOLAK 

 

Here's a little trick I use for cases like this: use a RecordID tool to assign a value to each row, convert that to a Double field, and add 0.5 to the records I want to stagger between. Check out the attached example to see this in action.

 

20200207-RecordStagger.PNG

G_WOLAK
7 - Meteor

I think I figured it out.  All I had to do was step away from my desk for a moment.

 

Just had to split the flow, keep the fields I wanted from each then union them back together. 

 

G_WOLAK_0-1581089915403.png

Labels