Icon

Automation-IDOC–Singapore—Main Workflow

Node 2Convert Doublesto StringNode 4Node 5Node 6Node 7Node 8Concatenateall columnsinto oneNode 12Node 37Node 38Node 45Node 46Node 47Node 48Node 50Node 108Node 109Node 110Node 111Node 112Node 113Node 114Node 115Node 116Node 117Node 118Node 119Node 120Node 121Node 122Node 123Node 125Node 369Node 370Node 371Node 376Arranging the columns in the order of outputSpacesNode 397Append spacecolumn todata columnSwitch backto horizontalConvert number ofspaces to actual spacesand concatenate withdata columnRemove thespace columnas it's alreadybeen added tothe dataNode 402Convert Doublesto StringNode 410Node 412Node 413Node 414Node 415Node 419Node 428Node 429Node 430Node 431Node 433Adding PO Number and Details TableSpliting the PO numberNode 436Node 438Node 439Node 440Node 441Node 442Cell Splitter Round Double Cell Splitter Column Filter String Manipulation Cell Splitter Column Filter Column Aggregator Joiner ConstantValue Column ConstantValue Column String Manipulation ConstantValue Column ConstantValue Column ConstantValue Column Column Filter Tika Parser Rule-basedRow Filter Cell Splitter RowID Transpose Rule-basedRow Filter Rule Engine Column Filter Missing Value Rule-basedRow Filter Row Filter Regex Split ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column String Manipulation String Manipulation Column Filter String Manipulation Column Expressions Column Resorter Table Creator Transpose Column Appender Transpose String Manipulation Column Filter CSV Writer Round Double CSV Writer Tika Parser String Manipulation String Manipulation Column Resorter String Manipulation ConstantValue Column String Manipulation Column Filter Column Expressions Column Expressions Column Appender Column Splitter Missing Value Column Expressions Column Filter Column Filter ConstantValue Column Column Expressions Node 2Convert Doublesto StringNode 4Node 5Node 6Node 7Node 8Concatenateall columnsinto oneNode 12Node 37Node 38Node 45Node 46Node 47Node 48Node 50Node 108Node 109Node 110Node 111Node 112Node 113Node 114Node 115Node 116Node 117Node 118Node 119Node 120Node 121Node 122Node 123Node 125Node 369Node 370Node 371Node 376Arranging the columns in the order of outputSpacesNode 397Append spacecolumn todata columnSwitch backto horizontalConvert number ofspaces to actual spacesand concatenate withdata columnRemove thespace columnas it's alreadybeen added tothe dataNode 402Convert Doublesto StringNode 410Node 412Node 413Node 414Node 415Node 419Node 428Node 429Node 430Node 431Node 433Adding PO Number and Details TableSpliting the PO numberNode 436Node 438Node 439Node 440Node 441Node 442Cell Splitter Round Double Cell Splitter Column Filter String Manipulation Cell Splitter Column Filter Column Aggregator Joiner ConstantValue Column ConstantValue Column String Manipulation ConstantValue Column ConstantValue Column ConstantValue Column Column Filter Tika Parser Rule-basedRow Filter Cell Splitter RowID Transpose Rule-basedRow Filter Rule Engine Column Filter Missing Value Rule-basedRow Filter Row Filter Regex Split ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column String Manipulation String Manipulation Column Filter String Manipulation Column Expressions Column Resorter Table Creator Transpose Column Appender Transpose String Manipulation Column Filter CSV Writer Round Double CSV Writer Tika Parser String Manipulation String Manipulation Column Resorter String Manipulation ConstantValue Column String Manipulation Column Filter Column Expressions Column Expressions Column Appender Column Splitter Missing Value Column Expressions Column Filter Column Filter ConstantValue Column Column Expressions

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: dd4
Created at: 2022-07-05
On NodePit since: 2022-09-23
Last update: 2024-12-21
Created with KNIME version: v4.6.1

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

Try NodePit Runner!