Hello People,
I am trying to find ideas on how to handle the following situation in power query
Imagine there are 4 tables which are sourced from different Excel Workbooks and elaborated individually before being appended into a unique table
My problem is that, one of the tables is not always present, hence, I would like to have flexible code so that, when there’s a missing table, the flow goes on and appends only the available ones instead of stopping and returning an error
So far I have been keeping a file in the folder containing only the headers and no other rows but I assume there must be a better option for this
I am looking for general ideas and techniques about how to approach this kind of situations
I have just attached 4 dummy files with the table and the missing table problem file which contains the power query consolidation
Thanks a lot for your precious help
Antonio
Missing Table Problem.xlsx (17.8 KB)
Order1.xlsx (12.1 KB)
Order2.xlsx (12.1 KB)
Order3.xlsx (12.1 KB)
Order4.xlsx (12.1 KB)