How to handle missing table in append

Hi @Anferrig,

Here’s a way to deal with such a case.
I’ve added a query called: EmptyTable with this code:
image

Next I restructured the code in one of the samples provided.

Changed “Sheet1” to “Sheet” to force an error

and that fixes the Result
Result

You will have to apply this if-then-else structure in all of the pre- append queries.
I hope this is helpful.

4 Likes