How to assign to a data.table a variable name received as parameter in a function

Question

I need have a data.table named "clients", the name is same that is in my database. (this example is with table "clients" but i will need more tables with others names)

tbl_import <- function (table)
{
        sql<-glue_sql(paste0("select * from table"),.con=con)
    
    table <- dbGetQuery(con,sql)
    setDT(table)
      
    table <<- copy(table)
        table <<- table ##I replace with this too in another try but didn't work either
}
tbl_import("clients")

When i run this i don't have the data.table with the name of "clients",I get a table with name "table"

Andrew Brown · Accepted Answer · 2022-09-30 04:32:05Z

2

Use assign() to create a variable with a custom name (table_name) in the caller environment (parent.frame()

tbl_import <- function (table_name) {
  sql <- glue_sql("select * from {`table_name`}",.con=con)
  x <- dbGetQuery(con,sql)
  assign(table_name, setDT(x), parent.frame())
}
tbl_import("clients")

answered Sep 30, 2022 at 4:32

Andrew Brown

1,0756 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

hfa Over a year ago

It works! Thank you so much for the help! "assign" was the key

an_ja · Accepted Answer · 2022-09-30 04:24:21Z

1

Just assign the function to a new name.

clients <- tbl_import("clients")

answered Sep 30, 2022 at 4:24

an_ja

4393 silver badges14 bronze badges

1 Comment

hfa Over a year ago

It works but Andrew response is more what i was looking for. with this solution i have to put twice the name of table and is just what i want to avoid. but thanks for response.

Collectives™ on Stack Overflow

How to assign to a data.table a variable name received as parameter in a function

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related