Results 1 to 4 of 4

Thread: How to exlude NULL values in my columns

  1. #1

    Question How to exlude NULL values in my columns

    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

  2. #2
    Lavastorm Employee stonysmith's Avatar
    Join Date
    Nov 2006
    Location
    Grapevine Tx
    Posts
    771

    Default

    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.

  3. #3

    Thumbs up Thank you very much, this works!!

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

    Cheers,

    DSabsi




    Quote Originally Posted by stonysmith View Post
    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.

  4. #4

    Default

    Hi @stonysmith , it worked! thank you very much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •