Hi everyone, I’m looking to use the readr library to enable me to read csv files (for I’m finding the CSV Reader node struggles with a few files I have). It was recommended that I use readr through this thread: [image] Error with File Reader node while running in a loop KNIME Analytics Platform I had a similar problem where there were some ‘dirty’ CSV files out of a large number of files and they were too large to just ‘edit’ them in Notepad++ (and that also was not a very nice process). I built a workflow using the R package readr, which seems to me more tolerant towards problematic CSV files and gives you some control how to handle mismatching quotes and so on. You might have to toy around with the settings of the read_delim function. [46] kn_example_import_csv_r_readr.knwf (52.… I’m struggling to get readr to work, however. I’ve downloaded R3.6.1 to my PC, and I’ve downloaded the appropriate libraries, but when I now try to point R Home to where R is stored (as opposed to the KNIME default) I get told the folder does not contain an R Executable. I’m trying to point R Home to: C:\Program Files\R\R-3.6.1 The only executable file is in C:\Program Files\R\R-3.6.1\bin but then I get the warning: Path to R Home does not contain a folder with name ‘bin’. It should be noted that when I point KNIME to use its default Path to R Home whilst I can get R to work it will not run the readr library, for the Snippet throws the following errors: Error: cannot read workspace version 3 written by R 3.6.1; need R 3.5.0 or newer Error: could not find function “read_delim” FYI I’m using 32bit Windows 10. Any help would be much appreciated. Thanks, Dom

Path to R Home does not contain an R Executable

armingrudd August 6, 2019, 11:44am 2

I think reading this post which is provided by @mlauber71 will help you:

2 Likes