LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: DSabsi

Dear all,

I need your help with excluding NULL values in my column.
Can anyone tell me how I can solve this ?
I've tried to use exclude NULL in a filter behind the Excel file but this is not working.

exclude NULL values in my columns.JPG

THank you in advance !

Cheers,

DSabsi

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Do you want to omit the entire row, or do you simply want it not to say "NULL"?

The Excel node has an option "NullRowBehavior" which you can set to Ignore so that you won't get the row at all.

If you want to convert "NULL" to some other value such as the empty string "", you can use a filter such as this:

emit *
override emit WIJKTEAM.ifNull("") as WIJKTEAM
override emit CLIENT.ifNull("") as CLIENT

and so on.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: DSabsi

Thank you very much, what you said works!!!

Cheers,

DSabsi

Originally posted by: stonysmith
					

Do you want to omit the entire row, or do you simply want it not to say "NULL"?


The Excel node has an option "NullRowBehavior" which you can set to Ignore so that you won't get the row at all.


If you want to convert "NULL" to some other value such as the empty string "", you can use a filter such as this:


emit *

override emit WIJKTEAM.ifNull("") as WIJKTEAM

override emit CLIENT.ifNull("") as CLIENT


and so on.
			

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: DSabsi

Hi @stonysmith , it worked! thank you very much