Hi, A question came up today on how to write data to excel that have un-equal nested lists. Sample list content: [image] And trying to map it to: [image] This will allow the List.Transpose and Excel.WriteToFile to work correctly. I have come up with the attached graph but it’s very rigid and…

If you transpose the list from the first picture the result should be the 2nd piucture

Sorry you’ll also need to replace the null values [image]

I need the nested lists to be the same size. ie. 7 items. My graph sample did the following: Found the longest length nested list looped through each nested list and add additional items to the list to get the list count to 7 items.

Sorry I must not be understanding. I thought you wanted a way to get what you had in the first picture to look like the 2nd picture but without you have to add “” to even up the lengths of the list The below outputs are identical from the 2 different lists you’ve given as inputs. [image] What yo…

My second image was just showing what I wanted the out in the Watch node to look like. I just don’t know the best way to get random lists to include the null values based on the maximum nested list length. So, The maximum nested length = 7 So I need to make sure all my nested lists length = 7 it…

Thanks Jimmy that worked when I added the second List.Transpose. I don’t fully understand how “by Replace Nulls” is actually working. How does it know where to add the Nulls to Replace?

The first transpose will add null values if it can’t find a value. If you don’t mind the values being nulls you can just transpose then transpose again without removing the nulls

Thanks Jimmy. Yea I needed to scroll down my Watch node on the First List.Transpose to see the input null values. This is what through me off.

Make all List Equal Length

Jimmy_G September 21, 2016, 2:46am 7

Basic list operation longest lace

Topic		Replies	Views
How to make "List A" length and the "List B" same Packages	4	371	January 14, 2016
Filling out list to have the same number of items with.. NULL	8	2131	December 16, 2016
Create empty list with n amount of rows	8	286	June 5, 2023
Sort list in a particular format revit , excel , dynamo	9	256	April 3, 2024
Configure Lists with n values Civil 3D	9	536	May 8, 2021

Make all List Equal Length

Related topics