Defining fields in an Output file

In Write to Spreadsheet, the Fields tab defines the names, position, and data types of the fields in the file. After you define an output file on the File Properties tab you can define the fields. If the option Nullable is checked and the Name field contains a null value, then the dataflow will write the null value in the spreadsheet.

If the output file contains a header record, you can quickly define the fields by clicking Regenerate.

To define fields with default values for position, length, and data type, click Quick Add and select the fields to add.

If the input file does not contain a header record, or if you want to manually define the fields, follow these steps:

  1. Click Add.
  2. In the Name field, choose the field you want to add.
  3. In the Type field, select the data type of the field coming from the dataflow.

    Spectrum™ Technology Platform supports the following data types:

    bigdecimal
    A numeric data type that supports 38 decimal points of precision. Use this data type for data that will be used in mathematical calculations requiring a high degree of precision, especially those involving financial data. The bigdecimal data type supports more precise calculations than the double data type.
    boolean
    A logical type with two values: true and false.
    bytearray
    An array (list) of bytes.
    Note: Bytearray is not supported as an input for a REST service.
    date
    A data type that contains a month, day, and year. For example, 2012-01-30 or January 30, 2012. You can specify a default date format in Management Console.
    datetime
    A data type that contains a month, day, year, and hours, minutes, and seconds. For example, 2012/01/30 6:15:00 PM.
    double
    A numeric data type that contains both negative and positive double precision numbers between 2-1074 and (2-2-52)×21023. In E notation, the range of values is -1.79769313486232E+308 to 1.79769313486232E+308.
    float
    A numeric data type that contains both negative and positive single precision numbers between 2-149 and (2-223)×2127. In E notation, the range of values -3.402823E+38 to 3.402823E+38.
    integer
    A numeric data type that contains both negative and positive whole numbers between -231 (-2,147,483,648) and 231-1 (2,147,483,647).
    long
    A numeric data type that contains both negative and positive whole numbers between -263 (-9,223,372,036,854,775,808) and 263-1 (9,223,372,036,854,775,807).
    string
    A sequence of characters.
    time
    A data type that contains the time of day. For example, 21:15:59 or 9:15:59 PM.
  4. Click Add.

After defining the fields in your output file, you can edit its contents and layout.

Option Name

Description

Add

Adds a field to the output. You can append a field to the end of the existing layout, or you can insert a field into an existing position and Write to Spreadsheet will adjust the remaining fields accordingly.

Modify

Modifies the field's name and type.

Remove

Removes the selected field from the output.

Move Up/Move Down

Reorders the selected field.