Standardize

Standardize data to a specified output format

This tool is currently in Beta and is still being tested. Want to learn more? Like to provide feedback? Please reach out to [e-mail]

Standardize gives the user the ability to standardize columns of data into a common, specified format.

Input/Output

Inputs	Outputs
Table with column(s) to be standardized	Standardized Table Unstandardized Table

Please Note: The 'Unstandardized Table' will contain any rows that failed to standardize within the tool.

Options

Inputs	Description
Column	Column to be standardized
Standardization Type	What data type is the column being standardized. Options: [Names, Phone Numbers, Dates, URLs, Postal Codes]
Format	What is the desired output format for the selected column and standardization type. Varies depending on standardization type selected.
Failure Handling	Determine how values which failed to be standardized will be handled. Options: [Fill with null value, Leave as-is, Remove entire row]

Formatting Options

Standardization Type	Format Options
Names	First Name, Last Name Title First Middle Last Suffix Last Name, First Name Last Suffix, Title First Middle
Phone Numbers	US International
Dates	Any Cascade supported DateTime format
URLs	http https www
Postal Codes	5 Digit 5 Plus 4 Either

Example

Let's say our goal is to take our 'Name' column and convert it into a standard format:

First Name, Last Name

Within the standardize tool, we would select the following items:

Standardization Type: "Names"

Column: "Name"

Formatting: "First Last"

Failure Handling: "Remove entire row"