Create Multiple Excel Files

This workflow demonstrates how to create/output multiple files with dynamic file naming using loop and path flow variable.

Input data is dummy data that consists of CustomerID, Product and Sales. Goal is to create one Excel file per each CustomerID. File name should consist of CustomerID and YYYY-MM suffix. In each loop iteration records associated with a single CustomerID are taken and a file name is created using String Manipulation node which joins flow variables from String Configuration and Group Loop Start nodes. String flow variable is then converted to path flow variable needed in Excel Writer. Relative path is used and files are written to the data folder within the workflow folder.

External resources

• Forum Topic