Input Record Format

The Enterprise Designer specifies the allowable input file formats for the type of dataflow in use. Typically, the dataflow would read the input record as either a text, database or XML file. Each of these input file types have specific format requirements which are covered in detail in the Spectrum™ Technology Platform Dataflow Designer's Guide. For instance, for an input text file, the guide covers the permitted record types, character encoding, field separators, etc.

The following are a couple of example input record text files. These example input records contain an optional header line, as well as optional input fields.

Example Geocoding Input Record

The following is an example text input record file with USA addresses.

mainAddress;areaName3;areaName1;postalCode;country
26 EDISON DR;NISKAYUNA;NY;12309;USA
92 MCCRACKEN RD;MILLBURY;MA;01527;USA
22 CARRIAGE LN;NEWARK;DE;19711;USA
8 HARBOR VIEW RD; S BURLINGTON;VT;05403;USA
124 VERNON RD;GREENVILLE;PA;16125;USA
31 FORD ST;MAUMEE;OH;43537;USA
155 WINTER ST;S WALPOLE;MA;02071;USA

Example Reverse Geocoding Input Record

The following is an example text input record file with input coordinates.

X|Y|Country
-72.672229|42.076406|USA
-82.436915|34.870463|USA
-95.7849|42.1603|USA
-113.532|53.5421|CAN
-71.2577|46.8461|CAN
-115.423|32.6561|MEX