Just wondering if any of your videos cover error handling in M Code. I couldn’t see any on quick review.
I have two situations I’m trying to address:
List item When retrieving a folder of excel files, how to ignore any files that contain errors (and reporting which files were ignored). I’d prefer not to just delete the row or replace with blank as that may cause other issues which could go unnoticed.
List item When merging 2 x queries, preventing an error if there isn’t any data in one of the tables. By way of example, we have a detailed forecast template and a summary forecast template. As we get close to end of year everyone is using detailed templates so there are no rows in the query that consolidates the summary template data. This returns an error so I load a template with 1 cent to force it to succeed. It would be a better outcome if we could use something like IF Merge with table 2 fails, use table 1 else merge Tables 1+2