Skip to main content

Varicent ELT Assistant

Reshape

Use the Reshape tool to 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.

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.

Configuring the Reshape tool

  1. Go to the Pipes module from the side navigation bar.

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

  3. In the Pipe builder, add a data source to your pipe. For more information on adding a data source, see the Data Input tool.Data Input

  4. Click symon_add_icon.png + Tool.

    The Tools modal opens, where you can add tools, such as the  Aggregate  tool, to your pipe.

  5. In the tools modal, search for Reshape. Click + Add tool.

    Tip

    You can also find the Reshape tool in the Organize section.

  6. Click the tool node and drag the line to the next tool to connect the tools. If you need to undo the action, click the line and then click Unlink.

  7. In the configuration pane, under Columns to rows - Rows to columns, toggle to switch to either turning columns into rows or rows into columns.

  8. In the Column to rows configuration, under Columns to row values, select the column(s) for rows.

  9. Under New label column name, enter the new name for the column.

  10. Under New value column name, enter the new value column name.

  11. In the Rows to columns configuration, under Label column, select the column(s) to label. Ensure that the column is unique from the Value column.

  12. Under Value column, select the value column. Ensure that the column is unique from the Labe column.

  13. Under the Rows to values columns, type a label value and press Enter or pick a suggestion from the list provided.