Forum Discussion

Hansdecocq's avatar
Hansdecocq
Frequent Visitor
4 years ago
Solved

How to extract table name from WEB import

Hey “POWER BI boy’s and girls” 😊   What is my help-question? How can I extract the generated name (see content “Web.BrowserContents” returned by the first the power query step?    What is the s...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    The name of the table comes from a caption tag buried in the Web.BrowserContents text.

     

    In this particular case, you can extract it like this:

    let
    Source = Web.BrowserContents("https://www.belastingdienst.nl/wps/wcm/connect/nl/douane_voor_bedrijven/content/hulpmiddel-wisselkoersen"),
    TableName = Text.BetweenDelimiters(Source, "<caption>", "</caption>")
in
    TableName
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

The name of the table comes from a caption tag buried in the Web.BrowserContents text.

 

In this particular case, you can extract it like this:

let
    Source = Web.BrowserContents("https://www.belastingdienst.nl/wps/wcm/connect/nl/douane_voor_bedrijven/content/hulpmiddel-wisselkoersen"),
    TableName = Text.BetweenDelimiters(Source, "<caption>", "</caption>")
in
    TableName
Hansdecocq's avatar
Hansdecocq
Frequent Visitor
4 years ago

Hey Alexis

I couldn't wait (:)) to try it tomorrow, so I did it 2 minutes ago.

  1. I created a new query with the data provided by you
  2. and...........Yep "TableName" has the (same) name like the main query.

(now I have to figure out the rest of the procedure, like extracting "month name and year". Thereafter I need to add two columns one with the constructed StartDateRates and the other with the EndDateRates.)
 
TOP!!!! Thank you for your help.