Icon

20220127_​Export CSV Files with Dynamic Names _​ LOCAL

File Management _ Export CSV Files with Dynamic Names

Workflow created for the KNIME forum ...

https://forum.knime.com/t/save-csv-files-in-a-loop-with-different-csv-names/39100

DESCRIPTION:
The Challenge is to export CSV multi file report with dynamic naming.

For this Example I have connected the workflow to a Google Drive file system storage. But the concept can be extrapolated to any other storage system.

For any comment or bug realted to the workflow, please do not hesitate to leave your comment.


DISCLAIMER:
The sharing of knowledge in KNIME Hub by using these examples and models, have only demonstration purposes in the advantage of the KNIME community.
These are meant to clarify theoretical background of mentioned subjects in caption.
I will not be held responsibility for any damages arising from the use of these models in your investment/valuation related work, without taking formal advise.

KNIME Forum challenge:Export CSV multi file report with dynamic naming Type Output Path: Fruit Retail DATAArranged by Client IDFruits in ColumnsExtractHeadersColnamesto columnextractCLASSESCLASSESuniqueID OutStart Loopby CLASS (Fruit)WiriteCSV to file Systemtime_nowStringpath:CLASS + time_now + extSystem Time...... to VariableCollectProcess VariablesNode 2011Output_PathArrange in RowsSplit CALSS andITEMClean UpSort Columns in Report OrderRename Report HeadersNode 2019Node 2020 Table Creator ExtractColumn Header Unpivoting Cell Splitter GroupBy Row Filter Table Row ToVariable Loop Start CSV Writer Java EditVariable (simple) Java EditVariable (simple) Create Date&TimeRange Table Rowto Variable Variable Loop End String to Path(Variable) Table Creator Unpivoting Cell Splitter Column Filter Column Resorter Column Rename Row Filter Column Appender KNIME Forum challenge:Export CSV multi file report with dynamic naming Type Output Path: Fruit Retail DATAArranged by Client IDFruits in ColumnsExtractHeadersColnamesto columnextractCLASSESCLASSESuniqueID OutStart Loopby CLASS (Fruit)WiriteCSV to file Systemtime_nowStringpath:CLASS + time_now + extSystem Time...... to VariableCollectProcess VariablesNode 2011Output_PathArrange in RowsSplit CALSS andITEMClean UpSort Columns in Report OrderRename Report HeadersNode 2019Node 2020 Table Creator ExtractColumn Header Unpivoting Cell Splitter GroupBy Row Filter Table Row ToVariable Loop Start CSV Writer Java EditVariable (simple) Java EditVariable (simple) Create Date&TimeRange Table Rowto Variable Variable Loop End String to Path(Variable) Table Creator Unpivoting Cell Splitter Column Filter Column Resorter Column Rename Row Filter Column Appender

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: RE90273
Created at: 2022-01-26
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.4.2

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

Try NodePit Runner!