Icon

IMAS_​Migration-HR

SOURCE: SHORTLIST
Microsoft SQL Server Connector
Apply correction
Excel Reader
Table BANKCODE
DB Table Selector
Raw BANKCODE
DB Reader
Clean BANK_CODE
String Manipulation
BANKCODE NOTES
Text View
Clean BANK_DESC
String Manipulation
Corrected join
Joiner
Create missingBANK_DESC_FINAL
Rule Engine
bank_code_final
Rule Engine
Corrected missingreference only
Rule-based Row Filter
Create missingBANK_CODE_FINAL
Rule Engine
bank_status_final
Rule Engine
final_status
GroupBy
bank_desc_final
Rule Engine
selected column
Column Filter
Clean EMPMAS BANK_CODE
String Manipulation
EMPMAS BANK_CODE not empty
Rule-based Row Filter
Table EMPMAS
DB Table Selector
Raw EMPMAS
DB Reader
Distinct EMPMAS BANK_CODE
Column Renamer
Issues list
Rule-based Row Filter
BANKCODE final valid only
Rule-based Row Filter
GroupBy
Status Validation
Rule Engine
Cleaned Column
Column Filter
Missing BANKCODE reference from EMPMAS
Rule-based Row Filter
Statistik
GroupBy
Rename column
Column Renamer
PROPOSED_BANK_DESC
Constant Value Column Appender
Export Issue
Excel Writer
BANKCODE final reference
Column Filter
VALID only
Rule-based Row Filter
Check EMPMAS BANK_CODE vs BANKCODE
Joiner
CLEANED DB
Microsoft SQL Server Connector
Load EMPMAS missing bank correction
Excel Reader
check
Text View
Check duplicate codes
Duplicate Row Filter
ACTION REMARK
Constant Value Column Appender
Insert to Cleansing DB
DB Writer
Excel 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: hanif
Created at: 2026-04-24
On NodePit since: 2026-04-25
Last update: 2026-04-25
Created with KNIME version: v5.11.0

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

Try NodePit Runner!