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.
Hello:
Can some body help me in conversion data in given form into proper tablular form in power query? Is this related to the concept of pivot and unpivot data.
registrationNumber | AYH566 |
archiveStatus | 0 |
country | UK |
customLabel | AYH566 - VPU 330 |
registrationNumber | ALG322 |
archiveStatus | 0 |
country | AL |
customLabel | ALG322 - SBLB-129 |
registrationNumber | AKY758 |
archiveStatus | 0 |
country | USA |
customLabel | AKY758 - 1648 hdm - |
registrationNumber | AKA749 |
archiveStatus | 0 |
country | FR |
customLabel | AKA749 VW 2KN |
registrationNumber | ALK431 |
archiveStatus | 0 |
country | UK |
customLabel | ALK431 -4MNB |
registrationNumber | AMK483 |
archiveStatus | 0 |
country | UK |
customLabel | AMK483 - VPU 330 |
Solved! Go to Solution.
Hi @mohsin-raza
You must do the following:
This is your source:
Click in Add Column -> Index Column and you get this:
Then select Index and (blank) columns and go to Transform and click on Pivot Column :
and you will get this:
Remove the Index column by right clicking and chosing Remove Column.
It's done!
You can replace all the null with blank by selecting all columns and go to Transform -> Replace Values
Regards,
Sérgio Silva
Glad i could help!
Hi @mohsin-raza
You must do the following:
This is your source:
Click in Add Column -> Index Column and you get this:
Then select Index and (blank) columns and go to Transform and click on Pivot Column :
and you will get this:
Remove the Index column by right clicking and chosing Remove Column.
It's done!
You can replace all the null with blank by selecting all columns and go to Transform -> Replace Values
Regards,
Sérgio Silva
Thanks for the solution . It looks very fine with the result you produced .
In step 2 when i select blank and index and chose Pivot column . I am not getting the same result. Pivot column also ask for choice of column ?
On selecting any of the column i am not getting the same answer..
can you see it?
and
Sorry @mohsin-raza i have updated my post.
Please check it again!
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |