Using City/State and ZIP Code for Last Line Lookup - 23.1

Spectrum Dataflow Designer Guide

Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Dataflow Designer Guide
First publish date
2007
Last updated
2024-05-09
Published on
2024-05-09T23:01:03.226155

To view all cities for a ZIP Code and all ZIP Codes for a City:

  1. In the LastLine field, enter a full or partial City/State and ZIP Code.
  2. Click Run Preview.
  3. In Preview Output Records on the right side of the pane, note that the results of the search, based on the scope of the input provided, have been placed in the appropriate output fields.

    Example: You enter "Wheaton IL 60187" in the LastLine field. The output records include "Wheaton IL 60187" and "Wheaton IL 60189". The output returns all cities for "60187" and all ZIP Codes for "Wheaton IL".