Forum Discussion
List.Zip Returning an error
Hi Rick_S137 ,
Has the issue been resolved on your end? If so, please share your solution and mark it as "Accept as Solution." This will assist others in the community who are dealing with similar problems and help them find a solution more quickly.
Thank you.
Hi lbendlin
For sample data I have made an example here, of a very minimized data set.
The data on the right is my end goal, which is simply a sum of each column.
List.Sum(
List.Transform(
List.RemoveItems(
List.Combine(
List.Transform(
Table.ColumnNames(Source), each Table.Column(Source, _))),
{"null"}
),
each Int64.From(_)
)
)
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlDSwYJjdaKV8kpzcoAcgtQAqzXEotAQlYlNCdXdaEhjQ9HNH0JRNHjUxgIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [A = _t, B = _t, C = _t, D = _t, E = _t, F = _t]),
l = List.Sum(List.Transform(List.RemoveItems(List.Combine(List.Transform(Table.ColumnNames(Source), each Table.Column(Source,_))),{"null"}),each Int64.From(_)))
in
lHow to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done". Once you examined the code, replace the entire Source step with your own source.