Examining NULL Values in Rows - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

A row may contain a NULL (empty) value for an attribute. You can examine NULL values for specific attributes or identify which rows across an entity contain NULLs by examining entity metadata. Metadata;Attributes (Entities)

To examine NULL count rows in a specific attribute

  1. In the Navigation View, click the Discover bar, then click the Entities tab.
  2. Expand the entity that contains the attribute whose duplicate rows you want to examine.
  3. Click the attribute.

    The Summary Data View opens for the selected attribute. (If the view does not open, click the Metadata Summaries icon on the Home tab.)

  4. Click the Content Summary tab, then click Completeness to expand it.
  5. Note the Null Count, if any.
  6. If NULL rows exist, click Null Count to open a List View of rows in which there are NULL values for the selected attribute.

To examine rows with NULL values in an entity

  1. In the Navigation View, click the Discover bar, then click the Entities tab.
  2. Click the entity with which you want to work.

    The Summary Data View opens for the selected entity. (If the view does not open, click the Metadata Summaries icon on the Home tab.)

  3. On the About tab, expand Source Properties and note the Attribute Count for this entity.
  4. Under View Details, click Row Value Counts.

    The Attribute Value Counts List View opens.

  5. Examine the row value counts.
  6. To view rows with NULLs, note any row that shows a Value that is less than the total number of attributes in the entity, if any.