Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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