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

Dealing with Horizontal Data

JBO
8 - Asteroid

Hello

I received an ugly horizontal data set. Here is an example of what it looks like (note, there are 66 names in my data with about 73 dates):

 

 

  Morrison, Jim Joplin, Janice Winehouse, Amy 
 1/1/15hoursratehoursratehoursrate
Type 11/1/15      
Type 21/1/15 15 18 17.75
Type 31/1/15      
 2/1/15hoursratehoursratehoursrate
Type 12/1/15      
Type 22/1/15 15.25 18.5 18.25
Type 32/1/15      

 

Here is the output I need: 

DateNameRate
1/1/15Morrison, Jim15
2/1/15Morrison, Jim15.25
1/1/15Joplin, Janice18
2/1/15Joplin, Janice18.5
1/1/15Winehouse, Amy17.75
2/1/15Winehouse, Amy18.25

 

I have already attempted this a few ways, but I am not able to solve it. Is there anything like a Multi-Column tool I could use to pair the rates in D, F, and H with the names in C, E, and G?

Any guidance on this one is much appreciated. 

Thanks in advance. 

Jen

2 REPLIES 2
JordanB
Alteryx
Alteryx

Hi @JBO

 

Please find attached a sample workflow which gets the desired output. I have added annotations within the workflow.

 

Best,

 

Jordan

JBO
8 - Asteroid

@JordanB, thank you so much! This is awesome.

My data is more complicated than what I shared here and I was able to use this as a foundation.