Reshape
Convert long-form data (many rows) to wide-form data (many columns) and vice versa.
Reshape your table to convert rows to columns or columns to rows. This is a way of transposing your data into another format.
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 tool.
Go to the Pipes module from the side navigation bar.
From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.
In Pipe builder, add your data source.
Click
+ Tool.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 88. 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.