Alteryx Designer Discussions

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

ROW TO COLUMN

razzy
8 - Asteroid

Hi everyone,

Hope everyone is keeping safe, i need help with transforming this dataset attached. Ideally i would want my coulmns to look like what i attached as " actual" in the sense that i want to make a the following transformation in the column field labelled name to be

"ID", "recorded_time" , "value" , "time"

For every ID that has unique values to all these fields in the data set these value are reported as the in the sheet "actual".

Please ignore the 400 values generated in the ID field the ID is the same in the data set for every unique entry.

Thanks in advance.

4 REPLIES 4
AbhilashR
14 - Magnetar
14 - Magnetar

Hi @razzy, give this workflow a try and let us know if this satisfies your ask.

AbhilashR_0-1592012286965.png

 

 

razzy
8 - Asteroid

Thanks for responding, almost there but the value of the recorder time for each ID uniquely for times 1 through 6 is the same but in the workflow output it is not consistent

AbhilashR
14 - Magnetar
14 - Magnetar

In other words the RECORDED_TIME date is the same for a given ID? If yes, then just delete the Multi-row formula tool I had in my original workflow.

AbhilashR_0-1592084501947.png

 

Your sample output had inconsistent dates for a given ID which confused me.

 
 

Capture.PNG

 

 

razzy
8 - Asteroid

Thank you very much, its perfect!!!!

Thanks again

Labels