+ Reply to Thread
Results 1 to 4 of 4

Thread: keep null values with data exclusion

  1. #1
    James Harrington
    Join Date
    Mar 2011
    Posts
    48
    Points
    1
    Answers Provided
    0


    0

    Default keep null values with data exclusion

    Hello

    I'm classifying point symbols based on a numeric field [result]. I want to exclude and display differently any data that has a "U" in a separate field [qualifier], this can be done with the 'data exclusion' feature, but all null values will be discarded. A null [qualifier] means the [result] is valid, and shall be displayed based on the quantity classification. Is there a way to include null values without editing the field or copying the layer & reclassifying? It makes no sense to me why null values must be eliminated.

    Thanks!

    James

  2. #2
    Marcin Gasior

    Join Date
    Oct 2010
    Posts
    450
    Points
    559
    Answers Provided
    91


    0

    Default Re: keep null values with data exclusion

    I confirm this strange behavior in AG10 sp4.
    Moreover, this same happens when Definition Query is set (eg. "A_strings" <> '1A' ) - besides the excluded value, all records with NULLs are excluded.

    In your case, when you want to preserve NULLs, you can try:
    "qualifier" IS NOT NULL

  3. #3
    James Harrington
    Join Date
    Mar 2011
    Posts
    48
    Points
    1
    Answers Provided
    0


    0

    Default Re: keep null values with data exclusion

    Thanks m.gasior :-)

    That works with a definition query, but not with quantity symbol classification using exclusions. For now, I populated all <null> values in [qualifier] with a "-" but in a table that looks like it means something. <null> indicates that the [result] is valid, so if there's anything in the [qualifier] field, that is a flag that alerts the user to a potential problem with the result.

    Is there an environment setting to handle null values this way? If not, can ESRI make this available soon? There are many other instances where this has been a problem for me.

  4. #4
    James Harrington
    Join Date
    Mar 2011
    Posts
    48
    Points
    1
    Answers Provided
    0


    0

    Default Re: keep null values with data exclusion

    ... a thought: I could change the "-" to a " " (space) so it looks blank to the user & not get tossed out as <null>...

+ Reply to Thread

Posting Permissions

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