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

...

  • Click one of the colored bars to select only the matching values in the column. See Select Column Values below.

Context menu:

Right-click the data quality bar to see a set of possible transformations:

  • Keep rows - Keep rows that match the data quality bar you selected.
  • Delete rows - Delete rows that match the data quality bar you selected.
  • Create new column flagging - Create a new column containing true for each row that matches the data quality bar you selected. Otherwise, the row value in the new column is false.
  • Clear values - For mismatched or empty rows, you can set the value to be empty.
  • Replace values - For mismatched or empty rows, you can replace with a specific value. See Replace Cell Values.

Unique Values

You can review the counts of the most frequently occurring values in the column.

...

.

To see all unique values, click Show more values.

  • Use the Search bar to locate specific values among the list of unique ones.
  • Click the Back button to return to the Selection Details panel.

Context menu:

Right-click any value bar to be prompted for a set of transformations specific to the applicable rows and values.

  • Keep rows with selected values - Keep rows where the selected value appears. Delete the other rows.
  • Delete rows with selected values - Delete rows where the selected value appears. Keep the other rows.
  • Create new column flagging - Create a new column containing true for each row that matches the selected value(s). Otherwise, the row value in the new column is false.
  • Clear values - You can set the row value to be empty for the selected value(s).
  • Clear others - You can set the row value to be empty for all rows that do not match the selected value(s).
  • Replace values - You can replace the selected value(s) with a specific value. See Replace Cell Values.

Patterns

Based on your selected column or column values, 

D s product
 attempts to find patterns that match your selections. These patterns are represented as 
D s item
itempatterns
. For more information, see Text Matching.

...

To see all patterns, click Show more patterns. For more information, see Column Details Panel.

Context menu:

Right-click any pattern bar to be prompted for a set of transformations specific to the rows and values that match the pattern.To see all patterns, click Show more patterns. For more information, see Column Details Panel

  • Keep rows with selected patterns - Keep rows with values that match the selected pattern(s). Delete the other rows.
  • Delete rows with selected patterns - Delete rows with values that match the selected pattern(s). Keep the other rows.
  • Create new column flagging - Create a new column containing true for each row that matches the selected pattern(s). Otherwise, the row value in the new column is false.
  • Clear values matching patterns - You can set the row value to be empty for the selected pattern(s).
  • Clear others - You can set the row value to be empty for all rows that do not match the selected pattern(s).
  • Replace values with matching patterns - You can replace the selected pattern(s) with a specific value. See Replace Groups of Values.

Other Selections

Select Multiple Columns

...