List filtering


#1

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

 


#2

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


#3

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


#4

Thanks Wy, Exactly what i needed.


#5

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