Forum Discussion
Solved
Splitting multiple columns using delimiter
I have table table which has 2 columns, both with a delimiters. I need to split the columns into rows using the delimiters, but maintain the matching sequence between the 2 columns. For example:...
Hi priyashah
Try applying the following steps:
1. Transpose the table
2. Split the column by delimiter
3.Promote first row to headers
4. Unpivot all the columns
The solution will give you the result you need for the given example.
You can also try another method.The steps are:1. Add custom column to split Column1 (Using Text.Split())
2. Add custom column to split Column2(Using Text.Split())
3. Combine the above two list to form a table (Using Table.FromColumns() )
4. Click the expand icon ( ) in the column header
5. Select the columns you want to keep and remove others
Syntax for Text.Split() Function: Text.Split([Column Name],"delimiter")
Syntax for Table.FromColumns() Function: Table.FromColumns({[Column Name1],[Column Name2],....})
Hope this solution is useful.Regards
Rohit
https://www.nimblelearn.com/using-dax-to-split-delimited-text-into-columns/
I think this is what you are looking for .
Thanks
Thanks for the response, but this is not what I am looking for.
This is splitting one column into multiple columns based on a delimiter or character.
I want to split more than one column into rows.