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:
|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|
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.