Reshape
Convert long-form data (many rows) to wide-form data (many columns) and vice versa.
Convert long-form data (many rows) to wide-form data (many columns) and vice versa.
When to use this tool
Use with the Forecast tool.
Input
The Reshape tool requires one data input.
Configuration
Use the following configuration options to help create your Reshape configuration.
In Pipe builder, add your data source.
Click
+Add Tool.Click See all tools.
In the search bar, search for Reshape. Click Add tool.
Tip
You can also find the Reshape tool in the Organize section.
Connect the tool to your data set.
In the configuration pane, enter the following information:
Table 60. Reshape tool configurationField
Description
Columns to rows - Rows to columns
Toggle to switch to either turning columns into rows or rows into columns.
Column to rows configuration
Columns to row values
Select the column(s) for rows.
New label column name
Enter the new name for the column.
New value column name
Enter the new value column name.
Rows to columns configuration
Label column
Select the column(s) to label. Ensure that the column is unique from the Value column.
Value column
Select the value column. Ensure that the column is unique from the Label column.
Row values to columns
Type a label value and press Enter or pick a suggestion from the list provided.