Table.Combine after checking table is not null

[Devesa_]

Hi everyone,
I am extraction information in chunks, and the idea is appending them all toghether in a new query.
The number of values differs so for some periods I'll need more or less queries (in this example Advisories10 to 14 are empty).

The issue is that when I try to append a query which is empty an the append fails.

Any idea of how to perform a check and then append only the non blank queries?

Thanks!

[Devesa_]

Great!
Thanks a lot!

[Vijay_A_Verma · Accepted solution]

In the below code, you need to define your ListOfTables to be combined which are name of Queries. So, just modify the first line. So your first line will be like (you will need to put all 14 queries here)

ListOfTables = {Advisories1, Advisories2, Advisories3,.......Advisories14}

let
    ListOfTables = {Table1, Table2, Table3},
    TableOfTablesToBeCombined = Table.RemoveRowsWithErrors(Table.FromList(ListOfTables, Splitter.SplitByNothing()), {"Column1"}),
    ListOfTablesToBeCombined = TableOfTablesToBeCombined[Column1],
    Result = Table.Combine(ListOfTablesToBeCombined)
in
    Result