Forum Discussion

nes_k4's avatar
nes_k4
Copper Contributor
Dec 01, 2021
Solved

Get data from web error - Expression.Error: There weren't enough elements in the enumeration to comp

Hello, I'm trying to get data from a table of URLs (for different stocks). Please see attached file. I've created a connection using one URL and then tried to get data from the table of URLs. I'm en...
  • Riny_van_Eekelen's avatar
    Dec 01, 2021

    nes_k4 Your query and function work just fine for all tickers where the data you want to extract is in the 8th table in the particular URL. However, some ticket numbers don't always return 8 tables (0 to 7). Inserted a step directly after the Source that filters for the table called "cnhk-list2", whatever list of tables is returned. Then it seems to work as desired. See attached.