Date being changed to double

So I have a workflow that reads in a list of files with “List Files/Folders” node, then in an R snippet reads each of the files and binds all of the rows and appends unique columns.

Screenshot 2024-04-18 153310

The code in the R snippet is:


fil_locat<- “C:\Docs\Data Science\Refresh_2024-03-20”

files_load ← list.files(path = fil_locat, pattern = “*.csv”, full.names = TRUE)
df ← files_load %>% map_df(~read_csv(.,col_names=TRUE,id=‘path’, show_col_types = FALSE)) %>% bind_rows() %>% clean_names() #%>%
write.csv(df,file=“C:\Docs\Data Science\Data\results_r.csv”, row.names=FALSE)
knime.out ← df %>%

While in the node, when I inspect either df or knime.out, the column cohort_day shows a date and shows to be of type date.

Screenshot 2024-04-18 153613

Screenshot 2024-04-18 153803

But examining the data Output of the node it shows “cohort_day” is now a double? With max and min values of 19799 and 19723 respectively which are typical excel date integers.

Screenshot 2024-04-18 153910

I guess I can convert them and write them back, but why the difference inside the node compared to what is being outputted by the node?

Hello @navywings
R work dates to column type unknown as standard; when exporting to KNIME as unknown you get a numeric conversion.

You can convert to string format straight away in your R script (and to date type later in KNIME, with the help of ‘string to Date&Time’ node).

Convert to string:

df$cohort_day <- as.character(df$cohort_day)

(*) just before write.csv and knime.out comands



Thanks @gonhaddock. Appreciate it.

1 Like