Forum Discussion
Helper IList.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.
Super UserThat's not at all what List.Zip is for. You should append these lists instead of zipping them, then filter them to throw out the blanks, and then List.Sum them.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Rick_S137Hi 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.
- lbendlin
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.