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

Name	Type	Description
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.

Unions

Uppercase Columns

Last modified 1yr ago