Icon

Process multiple files according to structure

Example of how different branches could be made active according to a file structure, using a Table Validator (Reference)

Example of how different branches could be made active according to a file structure, using a Table Validator (Reference)

CREATE LOCAL SAMPLE FILES find CSV filesloop pathsread csv filesfrom data areaformat1SWITCH(format valid -> TOPinvalid -> BOTTOM)process fileprocess fileend of path loopcollect data fromeach branchformat 1 dataformat 2 dataNode 44Node 45keep first rowkeep first rowformat 1format 2EXECUTE TO CREATESAMPLE DATAformat2SWITCH(format valid -> TOPinvalid -> BOTTOM)dummy nodeto convert switch from data portto variable portdummy nodeto convert switch from data portto variable portdummy nodeto convert switch from data portto variable portdummy nodeto convert switch from data portto variable portempty table to satisfy end ifempty table to satisfy end ifNode 72Node 73Node 74Node 45 List Files/Folders Table Row toVariable Loop Start CSV Reader Excel Reader Table Validator(Reference) Column Renamer Column Filter Loop End Table Creator Table Creator CSV Writer CSV Writer Row Filter Row Filter Excel Writer Excel Writer Excel Reader Table Validator(Reference) NoOp (Table) NoOp (Table) End IF End IF NoOp (Table) NoOp (Table) Empty Table Creator Empty Table Creator Row Splitter CSV Writer Row Splitter CSV Writer CREATE LOCAL SAMPLE FILES find CSV filesloop pathsread csv filesfrom data areaformat1SWITCH(format valid -> TOPinvalid -> BOTTOM)process fileprocess fileend of path loopcollect data fromeach branchformat 1 dataformat 2 dataNode 44Node 45keep first rowkeep first rowformat 1format 2EXECUTE TO CREATESAMPLE DATAformat2SWITCH(format valid -> TOPinvalid -> BOTTOM)dummy nodeto convert switch from data portto variable portdummy nodeto convert switch from data portto variable portdummy nodeto convert switch from data portto variable portdummy nodeto convert switch from data portto variable portempty table to satisfy end ifempty table to satisfy end ifNode 72Node 73Node 74Node 45List Files/Folders Table Row toVariable Loop Start CSV Reader Excel Reader Table Validator(Reference) Column Renamer Column Filter Loop End Table Creator Table Creator CSV Writer CSV Writer Row Filter Row Filter Excel Writer Excel Writer Excel Reader Table Validator(Reference) NoOp (Table) NoOp (Table) End IF End IF NoOp (Table) NoOp (Table) Empty Table Creator Empty Table Creator Row Splitter CSV Writer Row Splitter CSV Writer

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: BATEB031
Created at: 2024-04-20
On NodePit since: 2024-04-21
Last update: 2024-05-05
Created with KNIME version: v5.2.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!