Page tree

 

Support | BlogContact Us | 844.332.2821

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

In the Column Details panel, you can review additional details about a column of your dataset. Select Column Details from the Grid menu at the top of the Transformer Page or from any column menu.

  • From the Column Browser panel, you can display column details by clicking the Microscope icon next to a column histogram. See Column Browser Panel.
Tip

Tip: Use the Column Details panel to explore values in an individual column, when the context of the value is not important for your current exploration. For example, you can identify outlier values for the column or compare the number of unique values to number of rows to determine whether the column could be a key value.


D caption
typefigure
Column Details panel
Column statistics:

You can use this view to review basic counts and percentages of the values in the currently selected column. In addition to basic computations on valid, mismatched, and missing values, you can see breakdowns for the most frequent values and outlier values. 

d-s-profilingstats

Depending on the data type of the column, additional statistics provide information on data quality and variation. For more information, see Column Statistics Reference.

Explore values:

You can also use this panel to explore specific values that you select in the Column Browser. In the above image, a range of values has been selected in the left navigation panel. In the right panel, you can see the corresponding values as darker bars in related columns.

Actions:

  • To change the data type, click the type indicator next to the column title in the Column Details panel.
  • To perform commands on the column, select from the drop-down next to the column title. For more information, see Column Menus.
  • Use the data quality bar to select categories of values: valid, mismatched, or missing. The transform cards or Transform Editor are updated at the bottom of the screen based on your selection with recommended recipe steps.