File Reader Error - Cannot create URL of data file from

adjrock · March 22, 2019, 6:20am

Hi,
I’m trying to read csv files for which the directory is passed in by a variable into a File Reader node (Can’t use CSV Reader because of change lines within quotes) . The preview works perfectly but I get the following error:
“Cannot create URL of data file from ‘C:\Users\dxxxxx\Documents\file_0.csv’ in filereader config”

I tried the same but without using variable and it works perfectly. Hope someone can help
Thanks

lisovyi · March 22, 2019, 9:32am

If you use the absolute OS path to identify the file, then add file:/ in front of the flow variable (the hint is that it is also automatically prepended by KNIME, when you add it directly as a value in the node settings)

ScottF · March 22, 2019, 9:32am

EDIT: @lisovyi beat me to it.

adjrock · March 23, 2019, 9:43am

You guys are really good. Thanks a lot, that fixed my problem

system · March 30, 2019, 9:43am

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.