Forum Discussion
Need help on split and transpose values in imported JSON File
Hi..
I have imported JSON file into Power BI desktop. In Query editor I have converted list into table. Now my table data looks like below.
| Table Name | Column 1 | Column 2 | Column 3 | Column n |
| 1,2,3 | a | b | c | n |
| 4 | d | e | f | n |
| 5 | g | h | i | n |
I want result as below.
| Table Name | Column 1 | Column 2 | Column 3 | Column n |
| 1 | a | b | c | n |
| 2 | a | b | c | n |
| 3 | a | b | c | n |
| 4 | d | e | f | n |
| 5 | g | h | i | n |
I have used split by column and transpose. But I did not able to get the record in my required format. Could anyone please help me on this.
Thanks,
Chitra
Anonymous , split column as an option to split and create new rows. Use that.
4 Replies
Anonymous , In power query/edit query/data transformation mode, you have option split column by rows
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Hi amitchandak ,
My Question is different. If you see the table, 1st value of table name is 1,2,3. If i split that using split column by delimeter it will populate 1 as separate column 2 as separate column and 3 as seperate column. But I want 1 as seperate row 2 as seperate row and 3 as seperate row.
Even after converting everything into different column I cannot transpose row because I have follwing columns 4 and 5 which is populating correctly I should not disturb that. So kindly advice me on how o proceed with this.
Anonymous , split column as an option to split and create new rows. Use that.