I have started an internship and have to use KNIME analysics platform for the first time.
Now I am able to read an excel file and upload it to Sharepoint as a List.
The problem I have is that I have to keep automation in mind as a part of my internship. But I have no clue how I can change my workflow to automaticly fill in the name of the list (using the name of the excel file) that will be uploaded.
This is my current workflow.
Hello @SPL_Niels,
Welcome to the forum.
To extract the filename from the file you just imported. Click the flow variable button highlighted below.
Then select a name for your flow variable:
This generates a flow variable with the file location path, convert this to string using Path to String (Variable) node. Then use the String Manipulation (Variable) node to extract the file name from the path. Then use it to write your file.
Here is an example workflow for you to get started on this. Hope this helps.
Best,
Keerthan
