Upload Files and keep it in a temp folder related to work flow

[RamyHussein]

Hello,
I am asking for ideas

I have a work flow, connected to DATA BASE SAP HANA.
I want to join DATA base data with some manual DATA Based on “Project number”
The idea is to have a DATAAPP, that i can allow the user to upload the files “with standard format for sure”. then this file will be saved in a temp folder related to the work flow. after that and based on widget selection : project selection, the work flow can join the the data between files and data base.

I have an issue that i don’t know how to use “Upload file widget” and store the files in a “temp” folder related to the work?
Any help ?

[ActionAndi]

Hi,

I’ve done similar in the past using the KNIME server. What exactly is not working in your case?

The Excel-Reader is using the provided path variable:

[RamyHussein]

Thanks @ActionAndi
My concern: the work flow should be shared and i don’t want it to be connected to any folder in C:\ drive, it should be connected to a folder attached to current work flow itself.
Also about the Default File, how can i make it variable

[ActionAndi]

Ah I see!

Go to your workspace folder and find the workflow. Go into the folder and create an addtional folder “data”. Copy the default file into this folder.

Add the “Extract Context Properties” Node to get the Workflow-Folder. This is needed, as the folder changes if you copy it to the hub/server.

After that you can create the variable “DefaultPath” with string manipulation node:

Then apply this variable to the “File Upload Widget”

This might get a bit tricky as windows and linux systems use different slashes within the path definitions.

[RamyHussein]

Thanks @ActionAndi ,
for a reason that i don’t know, once i try to configure a Path in ““File Upload Widget”” it refuse to execute !