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.
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.
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
to act on remote Microsoft SQL Tables without needing to collect the data first.