Unable to Access PathOut Variable from Variable Creator in Excel Writer

[DanielHua]

Hi everyone,

I ran into a problem while building a simple workflow in KNIME and would like some guidance.

Here’s what I did:

• I used a Variable Creator node to create a variable called PathOut to store the output path.
• I wanted to pass this variable to an Excel Writer node so that it could be used when writing to an Excel file.
• However, I noticed that the variable is not being correctly recognized in Excel — the written file does not contain the value of PathOut.

What I have tried:

1. Ensuring that the variable name in the Variable Creator matches the one used in the Excel Writer.
2. Checking the Flow Variables tab in the Excel Writer node — the variable appears there but I am unable to bind it to the Path field.

Despite this, the issue persists. Could anyone advise on how to properly use a variable created in Variable Creator so that it can be accessed by the Excel Writer node? Or am I misunderstanding the difference between Variables and Flow Variables?

Thank you!

[mlauber71]

@DanielHua KNIME uses Path Variables. You will have to convert your string or create a new one.

Write multiple CSV file to a loop

@VJAM the creation of Flow Variables for Paths is maybe not 100% straightforward. Maybe this example might help to sort it out. The “path_values” is maybe not perfectly named. I think this is constructed that you could pass several Folder variables as collection strings. Also: CHunk Loop Start might have to be set to 1. Often I prefer the Table Row to Variable Loop Start node. [image] [image]

[Arunkumar_knime]

Hi @DanielHua,

Please convert the String to Path Variable as shown below.

#1.Add a String to Path(variable) node and select the string column to convert to Path.

#2. After creating the path, in Excel Writer, you would see the option as below.

Regards,
Arun

[DanielHua]

Thanks a lot for your reply!
I just tested using Table Row to Variable Loop Start, and it works perfectly for my case.
Really appreciate your help!

[DanielHua]

hi, Arukumar_knime

Thank you so much for your help! I followed your suggestion and it worked perfectly. I really appreciate your time and guidance.