Unpivot
Performs a UNPIVOT operation, rotating a table by transforming columns into rows

Parameters

Name
Type
Description
Is Optional
value_column
string
The name to assign to the generated column that will be populated with the values from the columns in the column list
name_column
string
The name to assign to the generated column that will be populated with the names of the columns in the column list
column_list
column_list
List of columns in the source table that will be narrowed into a single pivot column. The column names will populate name_column, and the column values will populate value_column.

Example

internet_sales = rasgo.get.dataset(74)
ds2 = internet_sales.unpivot(
value_column="SALES_FEES",
name_column="PRODUCT",
column_list=["TAXAMT", "FREIGHT"]
)
ds2.preview()

Source Code

RasgoTransforms/unpivot.sql at main · rasgointelligence/RasgoTransforms
GitHub
Copy link
Outline
Parameters
Example
Source Code