Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

D toc

Excerpt

Just below the column name in the data grid is a horizontal band, which identifies data quality issues among the sample values in the column.


D caption
typefigure
Data quality bars

...

ColorTypeDescription
GreenValidValid value for the currently selected data type.
RedMismatched

A value that does not match the listed data type. For example, if a column of Zip type contains, MISSING, it is considered a mismatched value.

For more information, see Find Bad Data.

BlackGrayMissing

Value is empty or null. For more information, see Manage Null Values.

...

Tip

Tip: The histogram may also show you unwanted variation in your values. For example, if the column stores latitude data, the precision may be too fine (e.g. 37.764013 and 37.76022 versus 37.76). You can use recipe steps the ROUND function to round your data to a more usable level of precision and thereby reduce the number of unique values in the column to a more manageable count. See ROUND Function.

For more information, see Supported Data Types.

D s also
inCQLtrue
label((label = "transform_ui") OR (label = "column_ui"))