Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
A piece of software I use exports its .csv files in a very... bad way. See below
Name | DescriptionA | ValueA | DescriptionB | ValueB | DescriptionC | ValueC |
Car1 | Door | 2 | Window | 4 | Trunk | 6 |
Car2 | Door | 5 | Window | 8 | Trunk | 1 |
I want to transform it from that to this:
Name | Description | Value |
Car1 | Door | 2 |
Car1 | Window | 4 |
Car1 | Trunk | 6 |
Car2 | Door | 5 |
Car2 | Window | 8 |
Car2 | Trunk | 1 |
So basically grouping all descriptions and values. I've tried every combination of pivot/unpivoting/transpose but I can't get the correct result! There's currently ~180 columns of that description/value format it spits out so if anyone has any tips it would be greatly appreciated!
Thanks,
Dave
Solved! Go to Solution.
See the attached file here. Hope it will help... See the Merged Table in Query Editor
Hi,
You may refer to my Blog article - Restructure the layout of datasets. Refer to Case 1.
Hope this heps.
Perfect thanks so much guys, really appreciate it!
Hi,
You may refer to my Blog article - Restructure the layout of datasets. Refer to Case 1.
Hope this heps.
See the attached file here. Hope it will help... See the Merged Table in Query Editor
Here are the steps
1) Unpivot all columns other than Car
2) Filter Rows that CONTAIN word "Description"
3) Add an Index Column
Now Create a Duplicate Query
1) Filter rows that CONTAIN word "Value"....
Now we can merge these 2 Queries
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |