# Standardize

{% hint style="info" %}
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>
{% endhint %}

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

![](https://2577551913-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MW_FvcY52Jcyt8JHFGs%2Fuploads%2F8OySuVFW63W6ES94dnFb%2Fstandardize_gif.gif?alt=media\&token=c3a76f15-9e38-4766-844a-37bf6d0a5e96)

### Input/Output

<table data-header-hidden><thead><tr><th width="235.5">Inputs</th><th>Outputs</th></tr></thead><tbody><tr><td>Inputs</td><td>Outputs</td></tr><tr><td>Table with column(s) to be standardized</td><td>Standardized Table<br>Unstandardized Table</td></tr></tbody></table>

{% hint style="info" %}
Please Note: The 'Unstandardized Table' will contain any rows that failed to standardize within the tool.
{% endhint %}

### Options

<table data-header-hidden><thead><tr><th width="235.5">Inputs</th><th>Outputs</th></tr></thead><tbody><tr><td>Inputs</td><td>Description</td></tr><tr><td><strong>Column</strong></td><td>Column to be standardized</td></tr><tr><td><strong>Standardization Type</strong> </td><td>What data type is the column being standardized. <br>Options: <strong>[Names, Phone Numbers, Dates, URLs, Postal Codes]</strong></td></tr><tr><td><strong>Format</strong></td><td>What is the desired output format for the selected column and standardization type. Varies depending on standardization type selected.</td></tr><tr><td><strong>Failure Handling</strong></td><td>Determine how values which failed to be standardized will be handled. Options: <strong>[Fill with null value, Leave as-is, Remove entire row]</strong></td></tr></tbody></table>

### Formatting Options

<table data-header-hidden><thead><tr><th width="235.5">Inputs</th><th>Outputs</th></tr></thead><tbody><tr><td>Standardization Type</td><td>Format Options</td></tr><tr><td><strong>Names</strong></td><td>First Name, Last Name<br>Title First Middle Last Suffix<br>Last Name, First Name<br>Last Suffix, Title First Middle</td></tr><tr><td><strong>Phone Numbers</strong></td><td>US<br>International</td></tr><tr><td><strong>Dates</strong></td><td>Any Cascade supported DateTime format</td></tr><tr><td><strong>URLs</strong></td><td>http<br>https<br>www</td></tr><tr><td><strong>Postal Codes</strong></td><td>5 Digit<br>5 Plus 4<br>Either</td></tr></tbody></table>

### Example

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

First Name, Last Name

![](https://2577551913-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MW_FvcY52Jcyt8JHFGs%2Fuploads%2FNBwLUJpRyCgE4haGWtLr%2FScreen%20Shot%202022-04-21%20at%2012.03.51%20PM.png?alt=media\&token=07ea2163-8820-4b77-8381-db8d43701f44)

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

Standardization Type: "Names"

Column: "Name"

Formatting: "First Last"

Failure Handling: "Remove entire row"

![](https://2577551913-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MW_FvcY52Jcyt8JHFGs%2Fuploads%2FV8mdpRLsX0uHL4Inkhif%2FScreen%20Shot%202022-05-04%20at%2010.13.16%20AM.png?alt=media\&token=abe97815-6214-4db3-b7b3-141d89114cd5)