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 |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |