LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  removing NULL from a field with a filter

    Employee
    Posted 06-21-2016 12:48

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

    Originally posted by: austenr

    Very new to Lavastorm (2nd day). How do you remove the NULL's from a column? Ive tried many combinations but cant seem to get a solution.

    emit '1:ASOH_ACCT_ID','1:ASOH_FNAME'
where
'1:ASOH_ACCT_ID' != 0
exclude '1:ASOH_FNAME' = "NULL"
    Any help appreciated. Thanks


  • 2.  RE: removing NULL from a field with a filter

    Employee
    Posted 06-21-2016 13:37

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

    Originally posted by: stonysmith

    See if this gives you what you want.

    emit '1:ASOH_ACCT_ID','1:ASOH_FNAME'
    where '1:ASOH_ACCT_ID' != 0
    or '1:ASOH_FNAME' != "NULL"


  • 3.  RE: removing NULL from a field with a filter

    Employee
    Posted 06-22-2016 03:46

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

    Originally posted by: awilliams1024

    Hi, just one other point of clarification on the 'null' values - are the values you are trying remove string literals containing the characters "NULL" (without the quotes) or are they actual NULL values?

    These two cases are treated differently. If it is the string "NULL" then the above solution is the one you want (though I'm not sure whether you want to use the 'and' operator rather than 'or' to combine the emit criteria). If you are dealing with NULL values then the second criterion would need to be:

    or isNotNull('1:ASOH_FNAME')

    Or if both criteria must be matched:

    and isNotNull('1:ASOH_FNAME')


    Regards,
    Adrian


  • 4.  RE: removing NULL from a field with a filter

    Employee
    Posted 06-22-2016 04:00

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

    Originally posted by: awilliams1024

    You may also be interested in the experimental 'Replace NULLs with Default Values' accelerator, see the attached dataflow

    removing_NULL_from_a_field_with_a_filter.brg

    You will need to have a recent version of LAE and LAL to be able to access the accelerators. See here for further details of how to access them:

    http://community.lavastorm.com/threa...erator-Library

    Note that the experimental accelerators are not covered by our normal support policy.

    Regards,
    Adrian


  • 5.  RE: removing NULL from a field with a filter

    Employee
    Posted 06-22-2016 07:19

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

    Originally posted by: awilliams1024

    In addition, there are two other experimental accelerators that may also be of interest: 'Split Nulls' and 'Split Blanks and Null Values' - see the attached updated dataflow:

    removing_NULL_from_a_field_with_a_filter_v2.brg