Forum Discussion

Rick_S137's avatar
Rick_S137
Icon for Helper I rankHelper I
1 year ago
Solved

List.Zip Returning an error

I have a column of my table containing only lists, the column contains 200+ rows and the lists them self are also 200+ digits. Ultimately I want to sum the columns of my table, so I may not be using ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
1 year ago

Hi Rick_S137 

Could you clarify what your table currently looks like, and the end result you want?

Should the result be a table or a scalar value? I'm not clear on what you mean by "sum the columns".

 

From your description, I would be looking at using List.Combine and List.Sum, along with List.RemoveNulls.

I don't think List.Zip is needed here from your description.

 

Regarding the error you are geting, it appears to be because you are passing a null value within the "list of lists" argument that List.Zip takes.

Rick_S137's avatar
Rick_S137
Icon for Helper I rankHelper I
1 year ago

Hi I have posted a much better explanation and included a link to it in the first post. Thank you for your suggestions