Forum Discussion

powelmac's avatar
powelmac
New Member
4 years ago
Solved

An error occurred in the ‘’ query. Expression.Error: The column of the table wasn't found.

Hi There,   Having some issues scraping financials from the web from multiple URLS.   The reason is that for some companies, they haven't yet reported their 06/2021 (FY21) numbers and some have. ...
Need Help
Tips and Tricks
  • Ehren's avatar
    Ehren
    4 years ago

    One approach would be to run some M over each nested table before expanding, to ensure they all have the columns you're expecting. If an expected column is missing, you could dynamically add it and populate it with nulls.

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
4 years ago

Hi powelmac ,

You can also try to split the query before 06/21 FY21, check the query result after it and replace error for them and merge the modified query result with the previous correct query.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.