Data Unpivot

Data Unpivot

Data Unpivot is located under Model Studio (   ) in Data Preparation, in the left task pane. Use the drag-and-drop method to use the algorithm in the canvas. Click the algorithm to view and select different properties for analysis.

Refer to Properties of Data Unpivot.



Properties of Data Unpivot

The available properties of Data Unpivot are shown in the figure below.



The depictions of tables and the change from one table structure to another are shown in the figure above. The elements A, B, and C of the first table are rearranged as shown in the second table.
The table below describes different fields present on the properties of Data Unpivot.

Field


Description

Remark

RunIt allows you to run the node.-
ExploreIt allows you to explore the successfully executed node.-
Vertical Ellipses

The available options are

  • Run till node
  • Run from node
  • Publish as a model
  • Publish code
-

Task Name

It is the name of the task selected on the workbook canvas.

You can click the text field to edit or modify the task's name as required.

Index Feature (A)

It allows you to select the variable(s) to be selected for the first column of the resultant table.

You can select a single or multiple variables.

Feature to Unpivot (B)

It allows you to select the variable(s) to be selected for the second column of the resultant table.

  • These are the variables that are unpivoted.
  • You can select multiple variables.
  • The variable selected as Index Feature (A) cannot be selected here. If you select it, the variable gets unselected and disappears from the Index Feature (A) selection.

Output Value Column Name (C)


It allows you to enter the Name to be given to the third column of the resultant table.

  • Make sure to enter an appropriate name for the rearranged variable.
  • It is necessary to enter this name, otherwise, you get a validation error.
  • The name appears in the resultant table obtained in the Data tab.

Output Variable Column Name (B)


It allows you to enter the Name to be given to the second column of the resultant table.

  • Make sure to enter an appropriate name for the values.
  • It is necessary to enter this name, otherwise, you get a validation error.
  • The name appears in the resultant table obtained in the Data tab.

Advanced

Node Configuration

It allows you to select the instance of the Amazon Web Services (AWS) server to provide control on the execution of a task in a workbook or workflow.

For more details, refer to Worker Node Configuration.

Example of Data Unpivot

Consider a Ship Mode dataset containing dispatch data for five consecutive years, shown in the figure below.




We select the following properties and apply Data Unpivot.

Index Feature (A)

Ship Mode

Feature to Unpivot (B)

2016 and 2017

Output Value Column Name (C)

Values

Output Variable Column Name (B)

Year


The figure below shows the resultant Unpivoted table on the Data tab.
You can see that the table structure has changed. The values for Year and Value variables are displayed, for all Ship Modes, one below the other.



    • Related Articles

    • Data Unpivot

      Data Unpivot is located under Model Studio ( ) in Data Preparation, in the left task pane. Use the drag-and-drop method to use the algorithm in the canvas. Click the algorithm to view and select different properties for analysis. Refer to Properties ...

    • Live Data

      Data visualization is the representation of data in the form of pictures, images, graphs, or any other form of visual illustration. In RubiThings, Live Data is visualized in the form of Line Chart, SolidGauge, and Speedometer. To fetch the live data, ...

    • Data Merge

      Data Merge is located under Model Studio ( ) in Data Preparation, in the task pane on the left. Use drag-and-drop method to use the algorithm in the canvas. Click the algorithm to view and select different properties for analysis. Properties of Data ...

    • Data Merge

      Data Merge is located under Model Studio ( ) in Data Preparation, in the task pane on the left. Use drag-and-drop method to use the algorithm in the canvas. Click the algorithm to view and select different properties for analysis. Properties of Data ...

    • Data Labels

      Data labels refer to the text, values, or a combination of both, that appear on a chart. For example, a data label on a Column chart gives you information about the variable plotted on the Y-axis corresponding to that column. By default, the data ...