Standardize
Standardize data to a specified output format
Last updated
Standardize data to a specified output format
Last updated
This tool is currently in Beta and is still being tested. Want to learn more? Like to provide feedback? Please reach out to support@cascade.io
Standardize gives the user the ability to standardize columns of data into a common, specified format.
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.
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] |
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 |
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"