Forum Discussion
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. ...
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.
Ehren
Microsoft Employee
Microsoft EmployeeOne 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.