Free Trial

Alteryx Designer Desktop Discussions

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

Transform data from one to one to one to many

PHaisten
6 - Meteoroid

I am trying to take some data and create a one to many relationship in Alteryx. I have attached some sample data to show what the input is and what I want to output to resemble. 

 

Input:Input.png

 

Desired Output:Desired Output.png

 

Was able to somewhat perform this using Multi-row formula to sequence each ID, then a Crosstab tool was able to line up the data but only for the IDs. All other data points were left off. 

 

Attempted to use a Transpose then concatenate using the Crosstab tool, but I am unable to parse the concatenated data once that is done. Is this possible to have the dataset transformed from one to one into one to many?

 

11 REPLIES 11
TimN
13 - Pulsar

The last one I sent has data in distinct columns without concatenation.  If you have a version with concatenation you can look at the Text to columns tool in the Parse folder that can separate into columns 

PHaisten
6 - Meteoroid

I was able to separate the data into separate columns using text to columns, just had to use the tool 6 times to separate all of my columns. Used a Select tool after that to order the data correctly. Thank you for your help!

Labels
Top Solution Authors