I have an XLS Reader node which reads a spreadsheet into my network. I then perform many transformations on the data before writing out the new data with an CSV Writer node. I want to capture and modify the filename as well, e.g.:
filename.xls -> filename - modified.csv
I have not been able to get the filename into a flow variable that I can then modify and use in the writer. I cannot apply workflow variables either in this node. Can anyone help me with the proper nodes-workflow?
The XLS Reader does not seem to expose the file folder-location. I have tried using a File Upload node to put the file into a variable, but although I set the XLS_LOCATION flow variable in the XLS Reader node, the select file to read is not filled in, and the node still asks me to select a file to read from.
If I apply a (global) workflow variable to the XLS_LOCATION variable in the XLS Reader, the dialog says that it is controlled by the variable, but still asks me for a file to read - does not seem to pick that up either.