Icon

Import Transactional Data

Note: ReceiptDate imported as Stringbecause it's blank for some rows! Note: ShipmentCost and ActualWeight importedas String because it's blank for some rows! Read Excel fileConnect to DBCreate tableLoadRAW_ShipmentHistory_EcolabRename fieldsRemove tableRead Excel fileRename fieldsCreate tableLoadRAW_InventoryHistoryRemove tableCreate tableRead Excel fileLoadRAW_ReplenishmentsRemove tableCreate tableLoadRAW_ShipmentHistory_PellaRead Excel fileRemove tableRename fieldsRename fields Excel Reader Microsoft SQLServer Connector DB Table Creator DB Loader Column Rename DB Table Remover Excel Reader Column Rename DB Table Creator DB Loader DB Table Remover DB Table Creator Excel Reader DB Loader DB Table Remover DB Table Creator DB Loader Excel Reader DB Table Remover Column Rename Column Rename Note: ReceiptDate imported as Stringbecause it's blank for some rows! Note: ShipmentCost and ActualWeight importedas String because it's blank for some rows! Read Excel fileConnect to DBCreate tableLoadRAW_ShipmentHistory_EcolabRename fieldsRemove tableRead Excel fileRename fieldsCreate tableLoadRAW_InventoryHistoryRemove tableCreate tableRead Excel fileLoadRAW_ReplenishmentsRemove tableCreate tableLoadRAW_ShipmentHistory_PellaRead Excel fileRemove tableRename fieldsRename fieldsExcel Reader Microsoft SQLServer Connector DB Table Creator DB Loader Column Rename DB Table Remover Excel Reader Column Rename DB Table Creator DB Loader DB Table Remover DB Table Creator Excel Reader DB Loader DB Table Remover DB Table Creator DB Loader Excel Reader DB Table Remover Column Rename Column Rename

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: angola
Created at: 2023-05-31
On NodePit since: 2023-06-06
Last update: 2024-11-21
Created with KNIME version: v4.7.3

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

Try NodePit Runner!