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:
Desired Output:
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?
Solved! Go to Solution.
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
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!