Icon

2021_​02_​16_​Create_​Multiple_​Excel_​Files

Create Multiple Excel Files
Create Multiple Excel FilesThis workflow demonstrates how to create/output multiple files with dynamic file naming using loop and path flow variable.Forum link: https://forum.knime.com/t/dynamic-filename-output-issues/30688 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 ofCustomerID and YYYY-MM suffix. In each loop iteration records associated with a single CustomerID are taken and a file name is created using String Manipulationnode which joins flow variables from String Configuration and Group Loop Start nodes. String flow variable is then converted to path flow variable needed in ExcelWriter. Relative path is used and files are written to the data folder within the workflow folder. Input dataGroup on CustomerIDDo some calculationCreate File NameInput file name suffixConvert to path flow variableOutput file per CustomerIDClose Loop Table Creator Group Loop Start GroupBy String Manipulation(Variable) StringConfiguration String to Path(Variable) Excel Writer Variable Loop End Create Multiple Excel FilesThis workflow demonstrates how to create/output multiple files with dynamic file naming using loop and path flow variable.Forum link: https://forum.knime.com/t/dynamic-filename-output-issues/30688 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 ofCustomerID and YYYY-MM suffix. In each loop iteration records associated with a single CustomerID are taken and a file name is created using String Manipulationnode which joins flow variables from String Configuration and Group Loop Start nodes. String flow variable is then converted to path flow variable needed in ExcelWriter. Relative path is used and files are written to the data folder within the workflow folder. Input dataGroup on CustomerIDDo some calculationCreate File NameInput file name suffixConvert to path flow variableOutput file per CustomerIDClose Loop Table Creator Group Loop Start GroupBy String Manipulation(Variable) StringConfiguration String to Path(Variable) Excel Writer Variable Loop End

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Johnny
Created at: 2019-01-03
On NodePit since: 2021-06-04
Last update: 2024-11-21
Created with KNIME version: v4.3.2
Tags: Excel FilesDynamic File NamesMultiple File OutputGroup Loop

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!