Merging multiple fields in your database in StreetSweeper Pro

Merging fields allow you to create a single address line if your database has address components split into several fields. It will also allow you to merge complete address lines to meet the 2 line Canada Post maximum.
Products affected: StreetSweeper® Pro

Merging fields allow you to create a single address line if your database has address components split into several fields. It will also allow you to merge complete address lines to meet the 2 line Canada Post maximum.

  1. After opening your file, the Field Mapping screen will appear. Drag the appropriate Field Name beside the first corresponding field in your input database.
  2. Drag the same Field Name beside the second corresponding field in your input database.
  3. Continue to drag the field name beside corresponding fields until all fields have been identified with the correct Field Name.
  4. Once all fields have been mapped, select OK.
  5. A box will appear prompting you to indicate the order of the fields you have selected. Each field will be separated by a space in the final, combined field.
  6. Drag the fields until they are in the correct order and select Done. If you have inadvertently mapped more than one field with the same Field Name, select Cancel to return to the Field Mapping screen and make corrections.

UPDATED: 04 January 2024