Edit Path in Java Edit Variable

[chaithuj]

I am using Java edit variable to add folder to the root dir based on need
String fname=“/NCL_Thomson_Settlements”;
String filename=“/Settlements_Prelim_File_Analysis_Fidelity”;
Input_Dir = N:\TOOLS\Allocaton Settlement Process Docs\CAL AUTOMATION

I am using this to get the Dir appeneded to the folder name and file name

out_excel_output = v_Input_Dir+fname+filename+“_QA”+“.xlsx”;
out_excel_dir = v_Input_Dir;
out_excel_folder = v_Input_Dir+fname ;
out_excel_file_name = v_Input_Dir+fname+filename+“_QA”+“.xlsx”;

The problem is its not letting me add \ but only allows me to use /
so my output is as below which si wrong
N:\TOOLS\Allocaton Settlement Process Docs\CAL AUTOMATION/NCL_Thomson_Settlements/Settlements_Prelim_File_Analysis_Fidelity_QA.xlsx

[chaithuj]

i fixed and it works
just use
String fname=“\NCL_Thomson_Settlements”;
String filename=“\Settlements_Prelim_File_Analysis_Fidelity”;

[chaithuj]

The output of a Java Edit Variable or Create File name legacy is a String Datatype
Output given is as below
N:\TOOLS\Allocaton Settlement Process Docs\CAL AUTOMATION\NCL_Thomson_Settlements\Settlements_Prelim_File_Analysis_Fidelity_QA.xlsx
I a trying to convert it as a Path using the node String to path Variable and the output now looks as
(LOCAL, N:\TOOLS\Allocaton Settlement Process Docs\CAL AUTOMATION\NCL_Thomson_Settlements\Settlements_Prelim_File_Analysis_Fidelity_QA.xlsx)
It is not recognized inExcel writer

[chaithuj]

I am trying to use this example, lost the link to tag the workflow

SAP2MDS_AUFM01_06.forum
SAP2MDS_AUFM01_06.forum.knwf (12.1 KB)
,.knwf

The output looks like this

/home/contiadmin/KNIME-output
I cannot execute as i don’t have this path., how do we create a path like this
/home/contiadmin/KNIME-output

[mlauber71]

@chaithuj this component will extract the absolute path of the workflow and the /data/ folder as well as the separator based on the system “path.separator.system” either / or \

Collect Local Metadata – mlauber71

[chaithuj]

Thank you let me try this