I have an sql table which I would like to pull into Rstudio using dplyr::tbl(). I would then like to use gather(), but I get the error.
Error in UseMethod("gather_") :
no applicable method for 'gather_' applied to an object of class "c('tbl_dbi', 'tbl_sql', 'tbl_lazy', 'tbl')"
Also, when reading https://db.rstudio.com/advanced/translation/ I did not see any info on using gather
I just wanted to:
- Confirm that
gather() is not available for SQL translation.
- Know possible alternatives to
gather()