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.

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.

Configuring the Reshape tool

  1. In Varicent ELT, go to the Pipes module.

  2. On the Pipes tab, find the pipe you want to work with. Click the pipe to open.

  3. In Pipe builder, add your data source.

  4. Click symon_add_icon.png + Tool.

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

    Tip

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

  6. Connect the tool to your data set.

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

    Table 69. 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.