Icon

File Management _​ Export CSV Files with Dynamic Names

File Management _ Export CSV Files with Dynamic Names
KNIME Forum challenge:Export CSV multi file report with dynamic naming Google Folder Connector. In case of a local system, the connector isn't needed ... folder path can be aggregated in 'Java Edit Variable' ( path: "Folder" + CLASS + time_now + ext ) ExtractHeadersColnamesto columnextractCLASSESCLASSESuniqueAuthentication toGoogle Services/My Drive/KNIME_publicFruit Retail DATA(Arranged by Client ID)ID OutStart Loopby CLASS (Fruit)Filter Columns Related to CLASSColumn Filter REGEX VariableWiriteCSV to file Systemtime_nowStringpath:CLASS + time_now + extSystem Time...... to VariableCollectProcess VariablesNode 2011 ExtractColumn Header Unpivoting Cell Splitter GroupBy GoogleAuthentication Google DriveConnector CSV Reader Row Filter Table Row ToVariable Loop Start Column Filter Java EditVariable (simple) CSV Writer Java EditVariable (simple) Java EditVariable (simple) Create Date&TimeRange Table Rowto Variable Variable Loop End String to Path(Variable) KNIME Forum challenge:Export CSV multi file report with dynamic naming Google Folder Connector. In case of a local system, the connector isn't needed ... folder path can be aggregated in 'Java Edit Variable' ( path: "Folder" + CLASS + time_now + ext ) ExtractHeadersColnamesto columnextractCLASSESCLASSESuniqueAuthentication toGoogle Services/My Drive/KNIME_publicFruit Retail DATA(Arranged by Client ID)ID OutStart Loopby CLASS (Fruit)Filter Columns Related to CLASSColumn Filter REGEX VariableWiriteCSV to file Systemtime_nowStringpath:CLASS + time_now + extSystem Time...... to VariableCollectProcess VariablesNode 2011 ExtractColumn Header Unpivoting Cell Splitter GroupBy GoogleAuthentication Google DriveConnector CSV Reader Row Filter Table Row ToVariable Loop Start Column Filter Java EditVariable (simple) CSV Writer Java EditVariable (simple) Java EditVariable (simple) Create Date&TimeRange Table Rowto Variable Variable Loop End String to Path(Variable)

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-01-27
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!