Options

The Extract to rows step has the following options:

Extract to rows step dialog box

Option

Description

Step name

Specifies the unique name of the Extract to rows step on the canvas. You can customize the name or leave it as the default.

Source hierarchical field

Specifies the hierarchical input field name from the previous step, which will be used to extract the data.

Pass through fields

Select to add the input fields to the output fields.

## Fields

Field

Description

Hierarchical data path

Complete path of the field name in the hierarchical field source.

Output field name

Name of the field that maps to the corresponding field in the hierarchical input source.

Type

Data type of the generated output field.

Path field name

(Optional) Adds the hierarchical path as a new output field with the specified name.

Last updated

Was this helpful?