Promote Subrecord stage

The Promote Subrecord stage is a restructure stage. It can have a single input link and a single output link.

.

The Promote Subrecord stage promotes the columns of an input subrecord to top-level columns. The number of output columns equals the number of subrecord elements. The data types of the input subrecord columns determine those of the corresponding top-level columns.

Shows a schematic of four columns in a subrecord being promoted to four top-level columns

The stage can also promote the columns in vectors of subrecords.

Shows columns from a vector of subrecords promoted to top-level columns

The Combine Records stage performs the inverse operation.

The stage editor has three tabs:

  • Stage tab. This tab is always present and is used to specify general information about the stage.
  • Input tab. This tab is where you specify the details about the single input set from which you are selecting records.
  • Output tab. This tab is where you specify details about the processed data being output from the stage.