Forum Discussion
Row transform nested values in one column and their corresponding nested values in another column
talbi ,
You can use a combination of the following:
Split Columns by Delimiter. For the Cities column you would use "|", and for the others use ",".
Once Split, you can use the Unpivot Columns to get the Columns into Rows.
Then use Filters or other Flags to Remove the unnecessary rows. Unfortunately, ran out of time to complete the entire manipulation, but hoping this at least gets you started.
Have attached pbix what I started.
EDIT: Found a better way. Attached is a revised pbix file. Please refer to PQ (2). Have only done it for Sales, but hope you can see the pattern to replicate the process.
Kind Regards,
talbi ,
You can use a combination of the following:
Split Columns by Delimiter. For the Cities column you would use "|", and for the others use ",".
Once Split, you can use the Unpivot Columns to get the Columns into Rows.
Then use Filters or other Flags to Remove the unnecessary rows. Unfortunately, ran out of time to complete the entire manipulation, but hoping this at least gets you started.
Have attached pbix what I started.
EDIT: Found a better way. Attached is a revised pbix file. Please refer to PQ (2). Have only done it for Sales, but hope you can see the pattern to replicate the process.
Kind Regards,