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

    Thanks for this (quick) reply. The first thing I'll do tomorrow is try this 🙂

    • Hansdecocq's avatar
      Hansdecocq
      Frequent Visitor
      4 years ago

      How do I reward you with Kudo's ????? ( This is new for me)

      • AlexisOlson's avatar
        AlexisOlson
        Super User
        4 years ago

        You can hit the Thumbs Up button on any message that deserves Kudos and click the Accept as Solution button for the message that resolved your question.

  • 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.