Skip to main content

Varicent ELT Help Center

Reshape

Abstract

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.

Configuring the Reshape tool
  1. In , add your data source.

  2. Click symon_add_icon.png +Add Tool.

  3. Click See all tools.

  4. In the search bar, search for Reshape. Click Add tool.

    Tip

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

  5. Connect the tool to your data set.

  6. In the configuration pane, enter the following information:

    Table 62. Reshape tool configuration

    Field

    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.