Skip to main content

Reshaping Steps

Recipe steps that change the number of rows in the dataset have additional impacts on your dataset and its samples. These reshaping steps include the following transformations:

Transformation

Documentation

Splitrows

Initial Parsing Steps

Expand Arrays into Rows

Working with Arrays

Filter Rows (keep or delete)

Remove Data

Pivot Table

Pivot Data

Unpivot Columns

Unpivot Columns

Join Datasets

Join Window

Union Datasets

Union Page

Select Lookup from the column menu

Lookup Wizard

Remove Duplicate Rows

Remove Data

Samples:

When one of these transformations is applied and rows are removed from your dataset:

  • Any samples generated before the step was added are invalidated and cannot be used.

  • If you edit steps in your recipe before this added transformation, any samples that you generated after the step are invalidated and cannot be used.

  • A valid initial sample is always available for use.

For more information, see Samples Panel.