I am working on a weekly report, where each week one column is added to an aggregated dataframe for further analysis.
I can get all of the data into the aggregated dataframe, and I am trying to have the name of this new column/variable automatically update.
For example, I need the new column/variable to be called "COST_12.24.21". I already have "12.24.21" saved as a string under the name "CURRENTDATE". For opening/downloading the raw/completed data, I have been able to use paste0() to mush together the date with the file name. I want to be able to do the same to mush together "COST_" and CURRENTDATE, but it gives an error/incorrect output every time.
Is there something similar that will let use my saved value CURRENTDATE in the variable name creation?
