Get an extract of the source web address to appear in a power query

[steve78]

Hi,

i would very much appreciate if anyone can help with something that i thought would have been possible but i am having no luck achieving it.

i run a power query that gets data from the web from the site https://en.wikipedia.org/wiki/London

and i am trying to get the "london" part of that web adress to appear as a column in my power query.

i know if i can get the address "https://en.wikipedia.org/wiki/London" , as a column in my power query, then i will know how be able to extract the "london" part by using split columns etc.

its just i cant get any of the actual source address text (above) and cant put it into the power query anywhere. Is this possible ??

i have attached my document , which is just a working doc of what im trying to achieve.

so i have a power query that gets the data from the web address of https://en.wikipedia.org/wiki/London

i have the web address in cell L1 and i have gived it a named reference of Address04

my source code for my power query

Please Login or Register  to view this content.

Really hoping that this is possible and someone can help me out with this, it would be very much appreciated, with many thanks, steve r

[steve78]

Hi, No ideas ladies and gents on this ???

[steve78]

i think the rules state i have to mention if i cross post the question.

so i have posed the question here also, in this case, im hoping to solve it quite quickly ( hopefully !! )

https://techcommunity.microsoft.com/...553928#M151989

thanks, steve

[alansidman]

It does not appear that London is part of the table you are bringing into PQ. If it is important to add a column with London, then you can do it by clicking on Add a column and then

="London"