As part of the normalization process, the InfoSum Platform lets you map US postal addresses in a source data file to the USA Address key in the Global Schema. Mapping US postal addresses to the Global Schema has a number of advantages:

• Three keys will be automatically generated after normalization (USA address, Zip9 and Zip5).
• US addresses can be entered in various formats.

Note: US address mapping is only available for US East Cloud Vaults and Bunkers.

Table of contents

Supported formats

Using the address mapper

Video tutorial

Creating custom keys

Normalizing for Activation Bunkers

Next steps

Supported formats

InfoSum verifies that the US address is valid and complete. You must always provide US addresses in raw format. 

The following Zip formats are supported by InfoSum Platform:

• Zip9 is accepted in two formats: 01740-1329 or 017401329
• Street address is required along with Zip code. The Platform cannot map or normalize Zip code on its own without a street. Both Street name and Zip code are required to validate an address.
• City and State are not mandatory values, unless zip code is not present.
• If an address has a Zip5, InfoSum Platform creates a Zip9 key.

Using the address mapper 

Video tutorial

Prior to normalizing your data you must have imported a file to your Cloud Vault. You can do this via the Import flow. Once you complete your import you’ll have to create a recordset before being able to normalize your data. 

For general information about the normalization step please read our Data Normalization article. You will need to be in the main Normalization screen to use the address mapper

1. To use Address Mapper, click on the black + icon on the right hand side, and select Address Mapper.

2.  This will open a modal where you can match column in your dataset to address mapper fields. 
3. Please ensure that you have selected the Address mapper Region on the dropdown as United States of America. Then you will see the following fields in green:
   1. House Number
   2. Address line 1/Full Address (you can include the street address and house number here)
   3. Address line 2
   4. Address line 3
   5. City
   6. State
   7. ZIP

4. Click on your columns (blue) to select a column if the address mapper hasn’t automatically selected the right column
5. Once you’re happy with the mapping, click on Add Address Mapper
6. You will see the address has been mapped in green and USA Address, Zip5 and Zip9 have been created as keys (the key toggle is automatically on)

Creating custom keys

If your collaboration requirements include other compound keys such as a full US address, you can easily create them using the modification options. 

1. Click on the black + buttom and select add modified column and select ‘Concatenate’ - this allows you to concatenate string values into one single string

2. A new modal will open, please select Add address mapped column as your input column. 

3. Then select the columns that you want to join, and give your new column a name. Click on add modified column.

4. Your new column will be added to the normalization table. It will be at the top in purple.

Normalizing for Activation Bunkers

If you’re planning to use any address column as an activation key, please toggle on the ‘export column’ toggle. 

Next steps

After normalizing the rest of your dataset you can prepare and publish to a new or existing Bunker.