List filtering

Hi,

I am having some difficulty finding a way to filter information coming out of excel.

I have a long list of sheet numbers and names which have a y/n variable in front, basically i want to filter out the null rows from the ‘y’ rows and produce usable lists for sheet creation.

Thanks in advance.

Capture

 

You could use ReplaceByCondition node to replace null values.

Put the Object.IsNull on condition input and replace null with your want.

Or use List.FilterByBoolMask node to Remove null values.

like the image blow

null

1 Like

And other useful tips for you x[1] means take the list x index 1

you can find more information on Python online Document on

https://docs.python.org/3/library/stdtypes.html?highlight=list#

null

Thanks Wy, Exactly what i needed.

Nathan Miller’s LunchBox also has a node for that.
remove Null