Skip To Content

Select fields

The Select fields tool maintains one or more specified fields in the output dataset. The output is a new dataset containing only the specified fields.

Examples

The Select fields tool can be used in scenarios such as the following:

  • Remove unwanted fields from a tabular dataset.
  • Select only the relevant fields before joining two datasets.
  • Select nested fields from within struct fields.

Parameters

The following table outlines the parameters used in the Select fields tool:

ParameterDescription

Input dataset

The dataset from which fields will be selected.

Fields

A list of the selected fields that will be maintained in the output dataset.

Usage notes

Use the Input dataset parameter to specify the dataset that contains the fields you want to select.

Use the Fields parameter to select the fields you want to keep. You can browse into fields of type struct to select one or more keys of interest and return them as new fields.

Outputs

The tool outputs the input dataset containing only the selected fields. Selected fields will be returned with their original name and type.

Licensing requirements

The following licensing and configurations are required:

  • Creator or Professional user type
  • Publisher, Facilitator, or Administrator role, or an equivalent custom role

To learn more about Data Pipelines requirements, see Requirements.