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

Resources