Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have a problem with Power Query. One of my columns is HTML table data like:
<table>
<tbody>
<tr><td valign="top">Contact_name</td><td>Jack</td></tr>
<tr><td valign="top">Gender</td><td>Male</td></tr>
<tr><td valign="top">Age</td><td>18</td></tr>
...
</tbody>
</table>
The HTML table contains the the column name and value:
Contact_name | Jack |
Gender | Male |
Age | 18 |
I want to convert the html table to new column like:
Any help that could be provided on my requirement would be greatly appreciated.😂
Thanks!
Solved! Go to Solution.
Hi @wdx223_Daniel ,
Thanks for your answer.
I finally find out the soultion:
Table.PromoteHeaders(Table.Transpose(Html.Table(Source, {{"Column1", "TABLE > * > TR > :nth-child(1)"}, {"Column2", "TABLE > * > TR > :nth-child(2)"}}, [RowSelector="TABLE > * > TR"])))
Hi @wdx223_Daniel ,
Thanks for your answer.
I finally find out the soultion:
Table.PromoteHeaders(Table.Transpose(Html.Table(Source, {{"Column1", "TABLE > * > TR > :nth-child(1)"}, {"Column2", "TABLE > * > TR > :nth-child(2)"}}, [RowSelector="TABLE > * > TR"])))