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 ...
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

     

     

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