dbplyr icon indicating copy to clipboard operation
dbplyr copied to clipboard

Unusual behaviour of dplyr::pull()

Open Nikeds opened this issue 1 year ago • 2 comments

  1. When I use dplyr ::tbl() function to get a table from snowflake and rename all the columns to upper case and then apply pull using dplyr::pull(FSYMTICKEREXCHANGE) it gives me the desired output

The Code : dplyr::tbl(ch, "univ_full_table") %>% rename_all(toupper) %>% dplyr::pull(FSYMTICKEREXCHANGE) (FSYMTICKEREXCHANGE is the column name in my table )

But, When I rename to upper case and then again rename to lowercase and apply pull using dplyr::pull(fsymtickerexchange) it gives the output as null

The Code : dplyr::tbl(ch, "univ_full_table") %>% rename_all(toupper) %>% rename_all(tolower) %>% dplyr::pull(fsymtickerexchange)

Result: NULL

Nikeds avatar May 08 '24 17:05 Nikeds