0

After I import big number of JSON files to Power Query, the last step I have to do is to transpose the the table (to make the rows are the columns).

Unfortunately, when I did the transpose, I found duplicate columns! (see attachments to have an idea about the situation)

enter image description here

enter image description here

I need a solution to transpose the rows or columns without having redundant columns as shown in the screenshots, and to have all values under the corresponding columns.

abdulrahman
  • 13
  • 2

1 Answers1

0

You should be transposing each individual JSON. Then when you append the JSONs together you wont have that issue

horseyride
  • 17,007
  • 2
  • 11
  • 22
  • Your solution does work, but what if I have big number of JSONs (in my situation I have around140 JSON files) – abdulrahman Jul 22 '23 at 20:56
  • Not sure why that matters – horseyride Jul 22 '23 at 23:19
  • I have around 140 imported JSON files, in order to do certain analysis on the data that it contain. so it is difficult to do the analysis for each file one by one. Also, I think it is not practical to apply your solution on that big number of files. – abdulrahman Jul 23 '23 at 06:17
  • You don't have to do the analysis one by one just the transpose and combine. If the number of files matters then you seem to be combining them manually which is the wrong approach – horseyride Jul 23 '23 at 10:52
  • You mean that to do the following: 1. Transpose each json file. 2. Combine all files after the traspose process. Please correct me if I'm mistaken. – abdulrahman Jul 23 '23 at 20:31
  • Correct that is it – horseyride Jul 23 '23 at 22:39