I am trying to take data from one Excel file and use the CSV Writer node to parse data from that file into two or three separate CSV files. Where I am getting hung up is dynamically creating a folder (in my file server) that will hold the CSV files. I would like to process (write) those files to a folder using a data element from a specific cell in the Excel file as the name of the file (i.e., specific product or company). I could end up with 100+ folders.
Any thoughts on the configuration of the CSV Writer node, or is there another node I would need to add to accomplish this?
This can not be done within CSV Writer node. Check out Create Folder and Create File/Folder Variables nodes. Adding them into flow should allow for folder/file creation based on data from Excel. Probably you’ll find design you need somewhere within @mlauber71’s links