Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello family,
I am trying to import data from Wikipedia. The link is HERE. The only problem I get when transforming this data is the missing URL (Link) from the column Link; at the end of the analysis, I want to have a visual with Links for each YouTube channel and to be dynamic in case of any changes from the website.
Thanks,
TM
Solved! Go to Solution.
Hi @tmhalila , in Power Query, in Html.Table (second step), insert this code (previous the full table extraction code) :
Html.Table(Origen, {{"Link", "a[href^=""http""]", each [Attributes][href]}
Like the image:
The result:
Best regards
Hi @tmhalila , in Power Query, in Html.Table (second step), insert this code (previous the full table extraction code) :
Html.Table(Origen, {{"Link", "a[href^=""http""]", each [Attributes][href]}
Like the image:
The result:
Best regards
This is much appreciated; You saved a lot. I was struggling to find out the Python solution.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |