Configuring Flow Variable for CSV Reader for Table Row to Variable Loop

I have a list of URLs to download CSV files that I want to read in the CSV reader.
Table Creator (contains column of URLs) > Table Row to Variable (takes each row as a variable) > CSV Reader (take the URL variable and read each file).
image

The problem is I don’t find the URL variable in the CSV Reader:
image

Would someone be able to assist me to understand how my configuration
can be fixed?

I’ve attached the workflow file:
VariableLoopCSVReader.knwf (10.4 KB)

Hi @ebecker1

Welcome to the KNIME community!

The issue here is that your URL is of type String. It needs to be of type Path. You can find this out by going to the CSV Reader node, Flow Variables and look for the file selection.

The icon indicates P for Path.

A such, add a String to Path node to convert it.

You’ll now find the flow variable being available for usage.

If applied properly, KNIME indicates it’s being used as such at the end of the configuration window.

Hope this helps!

4 Likes

Hi @ArjenEX, thank you for the solution, it works perfectly now.

2 Likes

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