'SQL' PIVOT and UNPIVOT

Extends the 'tidyverse' packages 'dbplyr' and 'tidyr' functionality with pivot(), i.e. spread(), and unpivot(), i.e. gather(), for reshaping remote tables. Currently only 'Microsoft SQL Server' is supported.

pivot

License Disclaimer

This pacakge was developed through funding and resources by the United States Veterans Health Administration and the VA Informatic and Computing Infrastructure (VINCI) by govornment employees. As such according to 17 U.S. Code §105 is not covered by copyright and is released to the public domain with no license restrictions. This code is released without any guarantee of suitability for any purpose.

Overview

The pivot R pacakge extends the capabilities of dbplyr to have pivot and unpivot capabilities. It currently works only for Microsoft SQL Server. For convenience it also provides extentions to the tidyr functions spread and gather to act on remote Microsoft SQL Tables without needing to collect the data first.