Icon

Automation-IDOC–Singapore

Node 2Convert Doublesto StringNode 4Node 5Node 6Node 7Node 8Concatenateall columnsinto oneNode 12Node 37Node 38Node 39Node 40Node 41Node 44Node 45Node 46Node 47Node 48Node 49Node 50Node 108Node 109Node 110Node 111Node 112Node 113Node 114Node 115Node 116Node 117Node 118Node 119Node 120Node 121Node 122Node 123Node 125Node 367Node 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 StringSpaces between each column of the tableAppend spacecolumn todata columnSwitch backto horizontalConvert number ofspaces to actual spacesand concatenate withdata columnRemove thespace columnas it's alreadybeen added tothe dataNode 410Concatenateall columnsinto oneNode 412Node 413Node 414Node 415Node 419Node 422Node 423Node 428Node 429Node 430Node 431Node 432Node 433Adding PO Number and Details TableSpliting the PO numberCell Splitter Round Double Cell Splitter Column Filter String Manipulation Cell Splitter Column Filter Column Aggregator Joiner ConstantValue Column ConstantValue Column Column Filter String Manipulation Rule Engine Column Filter String Manipulation ConstantValue Column ConstantValue Column ConstantValue Column Column Resorter 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 Cross Joiner String Manipulation Column Filter String Manipulation Column Expressions Column Resorter Table Creator Transpose Column Appender Transpose String Manipulation Column Filter CSV Writer Round Double Table Creator Column Appender Transpose String Manipulation Column Filter CSV Writer Column Aggregator Tika Parser String Manipulation String Manipulation Column Resorter String Manipulation Cell Splitter String Manipulation ConstantValue Column String Manipulation Column Filter Column Expressions Column Expressions Column Expressions Column Appender Column Splitter Node 2Convert Doublesto StringNode 4Node 5Node 6Node 7Node 8Concatenateall columnsinto oneNode 12Node 37Node 38Node 39Node 40Node 41Node 44Node 45Node 46Node 47Node 48Node 49Node 50Node 108Node 109Node 110Node 111Node 112Node 113Node 114Node 115Node 116Node 117Node 118Node 119Node 120Node 121Node 122Node 123Node 125Node 367Node 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 StringSpaces between each column of the tableAppend spacecolumn todata columnSwitch backto horizontalConvert number ofspaces to actual spacesand concatenate withdata columnRemove thespace columnas it's alreadybeen added tothe dataNode 410Concatenateall columnsinto oneNode 412Node 413Node 414Node 415Node 419Node 422Node 423Node 428Node 429Node 430Node 431Node 432Node 433Adding PO Number and Details TableSpliting the PO numberCell Splitter Round Double Cell Splitter Column Filter String Manipulation Cell Splitter Column Filter Column Aggregator Joiner ConstantValue Column ConstantValue Column Column Filter String Manipulation Rule Engine Column Filter String Manipulation ConstantValue Column ConstantValue Column ConstantValue Column Column Resorter 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 Cross Joiner String Manipulation Column Filter String Manipulation Column Expressions Column Resorter Table Creator Transpose Column Appender Transpose String Manipulation Column Filter CSV Writer Round Double Table Creator Column Appender Transpose String Manipulation Column Filter CSV Writer Column Aggregator Tika Parser String Manipulation String Manipulation Column Resorter String Manipulation Cell Splitter String Manipulation ConstantValue Column String Manipulation Column Filter Column Expressions Column Expressions Column Expressions Column Appender Column Splitter

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-17
Last update: 2024-04-27
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!