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