Variable error - startup

[Jeff]

Hi,

Hopefully a simple question… I receive the following error on a workflow from latest version (5.3) workflow…

WARN Excel Reader 5:1 Errors loading flow variables into node : Errors overwriting node settings with flow variables: Unknown variable “Path”
It’s a simple workflow where I scan a directory of excel files and loop through and to read/process them. I’m using what I believe to be a flow variable to pass from the Table Row Variable Loop Start to the Excel Reader.

While the flow works when I try to use in a batch file it gives me an error about path variable.

I’m just a little confused about how to use flow variables. I have watched the videos/read similar topics but am confused how to proceed to correct the error(s). As I said the flow works interactively but when trying to run from a command line errors giving an error about Path. Do I initialize a Path variable being empty so in the workflow it can use it?

Thanks for any insight.
Jeff

[mvalencia]

Did you include the Path variable in the Table Row to Variable Loop Start node? Check those settings.
Here’s an example of how these nodes should be configured: Importing Multing Delimited Files – KNIME Community Hub

[mlauber71]

@Jeff if you want to use the list files you can check this example:

Create individual excel files from multiple worksheets

@lazaronewhall17 yes this can be done. With such tasks you can combine several nodes into a system to handle your files. [image] You read the Excel Sheet names and feed them into a Table Row to Variable Loop start to iterate over them (you can expand this obviously to several files). You create Path variables for a new sub-folder: [image] Using the name of the “Sheet” as Folder name from the Flow Variable (you can use other things too, or you can just skip this part): [image] You then c…

@Jeff

While the flow works when I try to use in a batch file it gives me an error about path variable.

This does not make it clear if it does work when you use it in batch or it does not. Anyway. If you use KNIME in Batch mode the List Files and other nodes with Paths do not seem to work. From my perspective is is best to provide a basic workflow-variable with the start of the batch. See my article for more details:

KNIME Batch Processing on Windows and MacOS