Forum Discussion

RubenDB's avatar
RubenDB
Copper Contributor
Mar 19, 2021

Expression.Error the collumn from the table was not found

Dear   I'll make a cryptocurrencies overview for all my assets. I want to do this with data I get from a web page (coinmarketcap.com). So I make a link with my excell file. The data refreshed when ...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Mar 20, 2021

RubenDB Connected to the same table as in your 2nd screenshot, with the same script (in English though).All works well and refreshing works without problems. I can, thus, not replicate your problem.

 

But try this. Remove the "Type gewijzigd" step, so the PQ isn't looking for "Column1" to begin with. Do you really need to the step there? When I connect to the source both columns are already text, without the need for a data typing step.

RubenDB's avatar
RubenDB
Copper Contributor
Mar 20, 2021

Riny_van_Eekelen Thank you for your answer.

 

I don't understand what I have to do. This is the first time that I'm working with querry's. Understand code is the script. What do I have to change on this script?

 

let
Bron = Web.Page(Web.Contents("https://coinmarketcap.com/currencies/cardano/")),
Data0 = Bron{0}[Data],
#"Type gewijzigd" = Table.TransformColumnTypes(Data0,{{"Column1", type text}, {"Column2", type text}})
in
#"Type gewijzigd"

 

Only Column 2 have I need for working with.

 

Thanks

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 20, 2021

    RubenDB 

    Web site is not static, some script reload web page and update the information. In particular sequence of tables could be another. Thus as a minimum I'd suggest to take not a first table in the list, but filter it by name.

    let
    Bron = Web.Page(Web.Contents("https://coinmarketcap.com/currencies/cardano/")),
    #"Filtered Rows" = Table.SelectRows(Bron, each ([Caption] = "Cardano Price Today")),
    Data = #"Filtered Rows"{0}[Data]
in
    Data

     

    • RubenDB's avatar
      RubenDB
      Copper Contributor
      Mar 20, 2021

      SergeiBaklan Thanks Sergei

       

      I have tried this modification, but now I get another error named:

      "expression.error there weren't enough elements in the enumeration to complete the operation"

       

      Maybe it is needed to know that I have multiple databases from a dynamic web page. You can see on the picture all my querry's.

       

      Thank you for your patiently.

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Mar 20, 2021

    RubenDB In de lijst met toegepaste stappen: verwijder de stap "Type gewijzigd".

     

    Het script komt er dan zo uit te zien:

    let
Bron = Web.Page(Web.Contents("https://coinmarketcap.com/currencies/cardano/")),
Data0 = Bron{0}[Data]

in
Data0

     

     

    • RubenDB's avatar
      RubenDB
      Copper Contributor
      Mar 20, 2021

      Riny_van_Eekelen Bedankt voor je antwoord.

       

      Ik heb dit geprobeerd maar dan wordt niet de hele tabel geladen (zie foto).

       

       

Resources