We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

Comments

3 comments

  • Avatar
    Infogix Support
    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
  • Avatar
    Infogix Support
    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
  • Avatar
    Infogix Support
    Originally posted by: DSabsi

    Hi @stonysmith , it worked! thank you very much
    0
    Comment actions Permalink

Please sign in to leave a comment.