How to exlude NULL values in my columns

Follow

Infogix Support

• October 18, 2017 09:53

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

0

• 

  Infogix Support

  • October 18, 2017 15:06

  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.

  0

  Comment actions Permalink
• 

  Infogix Support

  • October 22, 2017 13:10

  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.
  			
  

  0

  Comment actions Permalink
• 

  Infogix Support

  • October 27, 2017 13:09

  Originally posted by: DSabsi
  
  Hi @stonysmith , it worked! thank you very much

  0

  Comment actions Permalink

Please sign in to leave a comment.