Hello, I want to do something like this, but I couldn’t find how I can accomplish something like this.
Read in a CSV File
Perform some operations on the data
Export an Excel file, to the same location as the input CSV file and use the filename as a base and add on current date to the out excel filename
This is so I don’t have to manually edit the output filename every time I run the workflow. Can someone please guide me on how to do this. Reading the documentation on the individual nodes did not help me understand the full picture.
Sure… First, You will read the file from a local or remote location? The name will be dinamically or static one?
Well, later, if you can bring a draw or flow example, can bem more clear, BUT i create something for you.
I’ll list files from a specific folder as default and searching by CSV files only.
It’ll create a list for me as references. After that, I’ll create a process to create a real path from each row to be used at the file creation and export process.
