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.
I need any related data to the employee ID to be on the same row. This over a larger data set than what I provided, so a filter would not work and it still does not place the related data into one row.
If you remove the filter, is that the output you want?
oops so sheet2 is what you have (input) but you want it like sheet1?
Output I am seeing is not all on the same row for each related user. In my output example I have the employee as one row and each dependent under that user is added on to the same row with new columns. Is this possible to perform in alteryx?
Sheet 1 is the data input. Sheet 2 is the desired output.
I think this one will do it.
The second one is what I am able to get, but the format needs to be each value associated with it must be in its own column. The Desired Output is what I need the data to be in. Once data is concatenated, is there a way to text to columns the data into individual columns?