Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
Great!
Thanks a lot!
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