The Fields Tab

The Fields tab allows you to designate fields to be returned in the output of your dataflow.
Note: The Query tab must be completed before the Fields tab is completed unless you are creating a custom query.

If you are using the query builder and have a field with a Dynamic Model Fields type, you can change the names of the fields that are returned for that step by selecting the step and clicking Modify. This will access the Modify Field dialog box, which contains a grid that is populated with fields and properties that map to the results of the step you selected. Similarly, the structure of this data is determined by whether you chose list output as well as the paths and names of the steps you entered on the Query tab.

If you are building a custom query, you can add, modify, or remove fields from your query.

Follow these steps to add fields to a custom query.
  1. Click Add to open the Add Field dialog box.
  2. Select the type of output field you want to add from the Field type drop-down box. The following data types are supported:
    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.
    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 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 4.9E-324 to 1.7976931348623157E308. For information on E notation, see en.wikipedia.org/wiki/Scientific_notation#E_notation.
    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 is 1.4E-45 to 3.4028235E38. For information on E notation, see en.wikipedia.org/wiki/Scientific_notation#E_notation.
    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.
    If you want to add a field from your model, select Dynamic Model Fields and the tab will be populated with fields and properties from your model. The structure of this data is determined by whether you choose list output as well as the paths and names entered on Add Field dialog box.

    You can also add a new, user-defined, custom data type if necessary. Among other types of data, a new type can be a list of any defined data type (though you could select most types from the drop-down options and click the List check box).

  3. Enter the Field name for the field you want to query in the model.
  4. Click List to return output in a hierarchical format; leave it unchecked to add prefixes to output fields.
  5. Click Cancel when you're done adding fields.
  6. Click OK.