Rule Explanations

Not Null

This rule ensures that the column does not contain any null values.

Format

This rule formats the values of the selected column in a specific way.

Allowed formats:

• Percent
• Decimal
• Currency
• Integer
• Many date formats
• All uppercase
• All lowercase
• Title case (first letter of each word capitalized)
• Snake case (all lowercase with underscores between words)
• Kebab case (all lowercase with hyphens between words)
• Float

Unique

This rule ensures that the column contains only unique values.

Default Value

This rule ensures that the column contains a default value.

Concatenate

This rule concatenates the values of the selected column with another existing column to create a new column.

Split Column

The opposite of Concatenate: splits the selected column into multiple new columns at a delimiter you choose. Name each resulting column, and choose whether to keep the original, un-split column.

Remove Duplicates

This rule ensures that the column does not contain any duplicate values.

Remove Spaces

This rule removes all spaces from the values of the selected column.

Remove Blank Rows

This rule removes all rows where every cell is empty or whitespace-only.

Remove Duplicate Rows

This rule removes extra rows that match an earlier row exactly in every column. The first occurrence is kept.