Forum Discussion

Devesa_'s avatar
Devesa_
Frequent Visitor
4 years ago
Solved

Table.Combine after checking table is not null

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!

 

 

Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    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

     

     

2 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    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