pivot (version 18.4.17)

unpivot_query: Create a pivot query representation

Description

Create a pivot table

Usage

unpivot_query(from, key, value, levels, select = character(0),
  order_by = NULL)

Arguments

from

the from clause

key

Variable columns originate from

value

The expression to evaluate to create the values

levels

the columns to turn into values of a variable.

select

variables to select in addition to levels.

order_by

optional order by clause