Forum Discussion
Appending remaining files if some are missing
Hello! I am loading and processing several files/connections and then I append them into one table. One of the files gets this error: Expression.Error: There weren't enough elements in the e...
Hi Anonymous
If a table doesn't exist, you could replace it with an empty table #table({},{}) and use this empty table in Table.Combine. Empty table could be appended to other tables.
emptyTable = #table({},{}),
AppendTable = Table.Combine({Table3, Table2, emptyTable})
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.