Open topic with navigation

Dynamic Fields Step

A Dynamic Fields step can add fields to, or remove fields from, a query object at runtime. Dynamic fields can be added by pivoting data from a single data source, or dynamically fetching metadata for field properties.

• Dynamic Mapping takes each field from the metadata result set and maps it to Query Object Field Properties. The primary mappings are Field ID, Field Name, Caption, and Data Type.

• Pivoting converts normalized, name-value paired data into flattened tabular data. The Pivot tab includes these fields.

  1. Pivot Columns: specifies which column has field ID and which column has value.
  2. Select Grouping: specifies grouping fields, which when grouped on, the normalized data converts to a flat table.