Using %userprofile% in a File Path

[XiozTzu]

I am trying to create a workflow that ends with writing an Excel file to the current users Windows Download folder. Typically, c:\Users\username\Downloads. I built the string in a String Manipulation (Variable) node shown below.

I tried to build the path using %userprofile% which windows will translate to C:\Users\username.

The flow variable after this step creates.

"%userprofile%\Downloads\ExcelFile_2024-02-07.xlsx"  

Which looks good.

I convert that to a path using String to Path (variable) and it creates.
“(LOCAL,
%userprofile%\Downloads\CQAActiveEmployees_2024-02-07.xlsx)”

Which still looks good.

When that path gets fed into the Excel Writer, I get the following error.

“Execute failed: The directory ‘C:\Users\username%userprofile%\Downloads’ does not exist and must not be created due to user settings.”

This is odd because it looks like Knime translated %userprofile% to “C:\Users\username” properly but did not take the alias out of the path.

What am I doing wrong? Is there a better way to reference the current users Download folder in Windows?

[prashant7526]

For me, it is easier to use Java Sniphet and make the path in the node.

[mlauber71]

@XiozTzu you can extract and use a lot of system properties with this node:

Extract System Properties

You can also use a node to ceate file paths:

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]