Icon

Column Splitter ycbing77 Rev 1

Read & CleanDataReplace "/"w/ ","Replace spw/ ","Remove DateColumnSplit Columnsw/ 2 ValuesLoop ThruData ColumnsKeep DateColumnName DateColumnAppendsAll ColumnsReorder/Rename ColumnsRemove HeaderRowManagesSingle OpAIDValueSets AllValues To StringsReplacesMissing ValuesAdds DateColumnFinal OutputExcel Reader String Manipulation(Multi Column) String Manipulation(Multi Column) Column Filter Cell Splitter Column ListLoop Start Column Filter Column Rename Loop End (ColumnAppend) Table Manipulator Row Filter Rule Engine Number To String Missing Value Joiner Table Viewer Read & CleanDataReplace "/"w/ ","Replace spw/ ","Remove DateColumnSplit Columnsw/ 2 ValuesLoop ThruData ColumnsKeep DateColumnName DateColumnAppendsAll ColumnsReorder/Rename ColumnsRemove HeaderRowManagesSingle OpAIDValueSets AllValues To StringsReplacesMissing ValuesAdds DateColumnFinal OutputExcel Reader String Manipulation(Multi Column) String Manipulation(Multi Column) Column Filter Cell Splitter Column ListLoop Start Column Filter Column Rename Loop End (ColumnAppend) Table Manipulator Row Filter Rule Engine Number To String Missing Value Joiner Table Viewer

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: genef
Created at: 2023-06-21
On NodePit since: 2023-06-27
Last update: 2024-04-27
Created with KNIME version: v4.7.4

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

Try NodePit Runner!