HomeStar Bill of LadingSetupConcatenating City, State, and Zip fields while importing Consignees

5.10. Concatenating City, State, and Zip fields while importing Consignees

To concatenate the fields using the import wizard you need to use this during
the import option.  Run the Import option, then during the mapping portion, 
you need to key in the following into the mapping Source associated to the 
proper address field.

(C + ", " + D + "  " + E)

Where C = City
Where D = State
Where E = Zip

This is based on the assumption that you are using an Excel spreadsheet to 
import.  Other file types are done the same way.

 

Here is the Expression builder in the import process.

 

This is what the Mapping screen like after you build the import expression.

 

This page was: Helpful | Not Helpful