Forum Discussion
Solved
Import data with Link from Web
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
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
2 Replies
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 regardsThis is much appreciated; You saved a lot. I was struggling to find out the Python solution.
