unpivot_query: Create a pivot query representation

In pivot: 'SQL' PIVOT and UNPIVOT

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

pivot documentation built on May 2, 2019, 2:02 p.m.