Import data with Link from Web

[tmhalila]

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

[Bifinity_75 · Accepted 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

[tmhalila]

This is much appreciated; You saved a lot. I was struggling to find out the Python solution.