Icon

IMAS_​Migration-HR

CLEAN POSKOD

CLEAN DATE

CLEAN MARITAL_STATUS

CLEAN PHONE

EMPMAS

BANKCODE

SKIMMAS

POSTDESC

JAWATAN

POSTMAS

POSTHISTORY

POSTMARA

HIS

POSTMARA

URUSAN

SCALESSM_D

SCALESSM_M

KELAYAKAN

EDUMAS

WARIS

TANGGUH

ELAUN

ELAUN

DEDMAS

DEDUCTION

DEDACCNT

NOTAX

Q_LEVEL

UNIVERSITY

SIJILTECH

IKTISAS_M

AHLI_IKTISAS

BINTANG

PREVPOST

OLDPOST

DEPENDENTS

SPOUSE

Export InvalidQ_LEVEL Records
Excel Writer
Filter Invalid Q_LEVEL
Rule-based Row Filter
Select CleanQ_LEVEL Columns
Column Filter
Filter ValidQ_LEVEL
Rule-based Row Filter
Read F Q_LEVEL
DB Reader
RenameQ_LEVEL for F
Column Renamer
Truncate F Q_LEVEL
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
Table F Q_LEVEL
DB Table Selector
Convert WARISNumber to Integer
Double to Integer
UNIVERSITY
DB Table Selector
Rename RawWARIS Columns
Column Renamer
Insert F Q_LEVEL
DB Writer
Clean NO_GAJI
String Manipulation
Convert UNIVERSITYNumber to Integer
Double to Integer
Convert WARISInteger to String
Number to String
Raw UNIVERSITY
DB Reader
Clean WAR_TEL
String Manipulation
Clean UNI_KOD
String Manipulation
Clean string column
String Manipulation (Multi Column)
Convert UNIVERSITYInteger to String
Number to String
CleanWAR_NEW_KP
String Manipulation
Clean UNI_DESC
String Manipulation
CleanWAR_OLD_KP
String Manipulation
Clean UNI_ABBR
String Manipulation
Status WAR_TEL
Rule Engine
StatusWAR_POSKOD
Rule Engine
Validate UNIVERSITY
Rule Engine
Status WAR_NEW_KP
Rule Engine
DuplicateUNI_KOD Check
GroupBy
StatisticUNIVERSITY Status
GroupBy
Statistic WARIS Status
GroupBy
Export duplicate
Excel Writer
Validate WARIS
Rule Engine
FilterDuplicateUNI_KOD
Rule-based Row Filter
StatisticWARIS Telephone
GroupBy
Export InvalidUNIVERSITY Records
Excel Writer
Statistic WARISPoskod
GroupBy
Filter InvalidUNIVERSITY
Rule-based Row Filter
Statistic WARISby NO_GAJI
GroupBy
Select CleanUNIVERSITY Columns
Column Filter
StatisticWARIS New KP
GroupBy
Filter ValidUNIVERSITY
Rule-based Row Filter
Select CleanWARIS Columns
Column Filter
Filter Valid WARIS
Rule-based Row Filter
RenameUNIVERSITY for F
Column Renamer
RenameWARIS for F
Column Renamer
CLEANED DB
Microsoft SQL Server Connector
Table F UNIVERSITY
DB Table Selector
CLEANED DB
Microsoft SQL Server Connector
Read F UNIVERSITY
DB Reader
Truncate F WARIS
DB SQL Executor
Truncate F UNIVERSITY
DB SQL Executor
Filter Invalid WARIS
Rule-based Row Filter
Insert F WARIS
DB Writer
Insert F UNIVERSITY
DB Writer
Raw TANGGUH
DB Reader
Validation lookupKELAYAKAN
DB Query Reader
Export InvalidWARIS Records
Excel Writer
Missing Reference
DB Query Reader
Convert TANGGUHNumber to Integer
Double to Integer
Raw SIJILTECH
DB Reader
TANGGUH
DB Table Selector
Uni missing ReferenceKelayakan
Excel Writer
Clean TANGGUHNumeric StringColumns
String Manipulation (Multi Column)
Convert TANGGUHInteger to String
Number to String
SIJILTECH
DB Table Selector
CleanKOD_TANGGUH
String Manipulation
Convert SIJILTECHInteger to String
Number to String
Convert SIJILTECHNumber to Integer
Double to Integer
StatusTKH_TANGGUH
Rule Engine
Clean SIJIL_DESC
String Manipulation
Status TKH_ASAL
Rule Engine
Clean SIJIL_TECH
String Manipulation
PrepareTKH_ASALParse Value
Rule Engine
StatisticSIJILTECH Status
GroupBy
StatusTKH_ENTRY
Rule Engine
Validate SIJILTECH
Rule Engine
PrepareTKH_ENTRYParse Value
Rule Engine
Filter DuplicateSIJIL_TECH
Rule-based Row Filter
PrepareTKH_TANGGUHParse Value
Rule Engine
DuplicateSIJIL_TECH Check
GroupBy
RenameTKH_ASAL_PARSED
Column Renamer
Parse TKH_ASAL
String to Date&Time
Export duplicate
Excel Writer
ParseTKH_TANGGUH
String to Date&Time
Export InvalidSIJILTECH Records
Excel Writer
Filter InvalidSIJILTECH
Rule-based Row Filter
ParseTKH_ENTRY
String to Date&Time
Select CleanSIJILTECH Columns
Column Filter
RenameTKH_TANGGUH_PARSED
Column Renamer
Filter ValidSIJILTECH
Rule-based Row Filter
Read NORMALIZED_HRref_post_master
DB Reader
ValidateTANGGUH
Rule Engine
Table FSIJILTECH
DB Table Selector
LookupPOSTHISTORYPost Master
Joiner
RenameTKH_TANGGUH_PARSED
Column Renamer
RenameSIJILTECH for F
Column Renamer
StatusPOSTHISTORYPost Lookup
Rule Engine
StatisticKOD_TANGGUH
GroupBy
CLEANED DB
Microsoft SQL Server Connector
Tableref_post_master
DB Table Selector
StatisticTANGGUH Status
GroupBy
Truncate F SIJILTECH
DB SQL Executor
Truncatestaff_position_history
DB SQL Executor
TANGGUH IssueList Columns
Column Filter
Insert FSIJILTECH
DB Writer
Selectstaff_position_historyColumns
Column Filter
FilterInvalid TANGGUH
Rule-based Row Filter
Read FSIJILTECH
DB Reader
Tablestaff_position_history
DB Table Selector
Add TANGGUHAction Remark
Constant Value Column Appender
Read NORMALIZED_HRstaff_position_history
DB Reader
Add TANGGUHCorrection Value
Constant Value Column Appender
Raw POSTMARA
DB Reader
Insertstaff_position_history
DB Writer
IKTISAS_M
DB Table Selector
Export TANGGUHInvalid Records
Excel Writer
Clean IKTISAS_CD
String Manipulation
Raw IKTISAS_M
DB Reader
POSTMARA
DB Table Selector
Select CleanTANGGUH Columns
Column Filter
CleanIKTISAS_ABBRV
String Manipulation
FilterValid TANGGUH
Rule-based Row Filter
CleanIKTISAS_DESC
String Manipulation
ConvertPOSTMARAInteger to String
Number to String
CLEANED DB
Microsoft SQL Server Connector
StatisticIKTISAS_M Status
GroupBy
ConvertPOSTMARANumber to Integer
Double to Integer
RenameTANGGUH for F
Column Renamer
ValidateIKTISAS_M
Rule Engine
Clean PM_SCALE
String Manipulation
Insert FTANGGUH
DB Writer
FilterDuplicateIKTISAS_CD
Rule-based Row Filter
CleanPOSTMARANumeric StringColumns
String Manipulation (Multi Column)
Truncate F WARIS
DB SQL Executor
DuplicateCheckIKTISAS_CD
GroupBy
Clean PM_STATUS
String Manipulation
Read F TANGGUH
DB Reader
Clean PM_SKIMX
String Manipulation
Table F TANGGUH
DB Table Selector
Export duplicate
Excel Writer
Clean FLEKSI_GRED
String Manipulation
Clean FLEKSI_YN
String Manipulation
Statistic F TANGGUH Status
GroupBy
Clean PM_FILLER
String Manipulation
Raw ELAUN
DB Reader
ELAUN
DB Table Selector
StatusFLEKSI_DATE
Rule Engine
Convert ELAUNInteger to String
Number to String
StatusPM_CRET_DATE
Rule Engine
Convert ELAUNNumber to Integer
Double to Integer
renamePM_CRET_DATE_PARSED
Column Renamer
Clean ELN_TYPE
String Manipulation
ParsePM_CRET_DATE
String to Date&Time
Clean ELAUNNumeric StringColumns
String Manipulation (Multi Column)
renameFLEKSI_DATE_PARSED
Column Renamer
StatusELN_END
Rule Engine
ParseFLEKSI_DATE
String to Date&Time
StatusELN_START
Rule Engine
PreparePM_CRET_DATEParse Value
Rule Engine
Filter ParseReady ELN_START
Rule-based Row Filter
Prepare ELN_STARTParse Value
Rule Engine
ValidatePOSTMARA
Rule Engine
PrepareFLEKSI_DATEParse Value
Rule Engine
Prepare ELN_ENDParse Value
Rule Engine
StatisticPOSTMARA Status
GroupBy
ParseELN_START
String to Date&Time
Filter ParseReady ELN_END
Rule-based Row Filter
StatisticFLEKSI_YN
GroupBy
Rename parseto date
Column Renamer
StatisticPM_STATUS
GroupBy
Parse ELN_END
String to Date&Time
FilterDuplicatePOST_NUM
Rule-based Row Filter
StatisticELAUN Status
GroupBy
StatisticDuplicatePOST_NUM
GroupBy
Validate ELAUN
Rule Engine
Select CleanPOSTMARA Columns
Column Filter
StatisticELN_TYPE
GroupBy
Filter ValidPOSTMARA
Rule-based Row Filter
Export ELAUNStatus Statistic
Excel Writer
Truncate F POSTMARA
DB SQL Executor
Rename POSTMARAfor F
Column Renamer
StatisticELN_KOD
GroupBy
CLEANED DB
Microsoft SQL Server Connector
Export InvalidELAUN Records
Excel Writer
Filter InvalidELAUN
Rule-based Row Filter
Table F POSTMARA
DB Table Selector
Select CleanELAUN Columns
Column Filter
Insert F POSTMARA
DB Writer
Filter Valid ELAUN
Rule-based Row Filter
Checkstaff_service vs POSTDESC
Joiner
Select POSTMARANormalized Columns
Column Filter
Truncate F ELAUN
DB SQL Executor
Readref_position_description
DB Reader
Read F POSTMARA
DB Reader
RenameELAUN for F
Column Renamer
Statistic Position Lookup
GroupBy
CreatePOSTMARAsource_key
String Manipulation
Table F ELAUN
DB Table Selector
StatusPosition Lookup
Rule Engine
Rename POSTMARAfor NORMALIZED
Column Renamer
CLEANED DB
Microsoft SQL Server Connector
MissingPosition Summary
GroupBy
NORMALIZED DB
Microsoft SQL Server Connector
Insert F ELAUN
DB Writer
Filter MissingPosition Reference
Rule-based Row Filter
Tableref_post_master
DB Table Selector
Read F ELAUN
DB Reader
Add PositionAction Remark
Constant Value Column Appender
ref_post_masterlookup columns
Column Filter
Add ProposedPosition Desc
Constant Value Column Appender
Readref_post_master
DB Reader
Load MissingPosition Correction
Excel Reader
Export MissingPosition Reference
Excel Writer
ELNMAS
DB Table Selector
Check POSTMARAvsref_post_master
Joiner
Convert ELNMASNumber to Integer
Double to Integer
Raw ELNMAS
DB Reader
FilterCorrected Position
Rule-based Row Filter
Finalref_post_maraColumns
Column Filter
Clean ELN_KOD
String Manipulation
Status POSTMARAPost Master Lookup
Rule Engine
Convert ELNMASInteger to String
Number to String
ValidateCorrected Position
Rule Engine
Insertref_post_mara
DB Writer
Clean ELN_SLIP_DESC
String Manipulation
CreatePosition Desc Final
Rule Engine
Truncateref_post_mara
DB SQL Executor
Clean ELN_DESC
String Manipulation
Select CorrectedPosition Columns
Column Filter
Filter MissingPOSTMARA Post Master
Rule-based Row Filter
Clean ELN_GL_KOD
String Manipulation
Filter ValidPositionCorrection
Rule-based Row Filter
StatisticPOSTMARA Lookup
GroupBy
Clean ELN_GL_SIGN
String Manipulation
Add CorrectionETL Status
Constant Value Column Appender
Export MissingPOSTMARAPost Master
Excel Writer
Rename CorrectedPosition Columns
Column Renamer
MissingPOSTMARAPost Master Summary
GroupBy
Clean ELN_TAX
String Manipulation
Originalref_position_descriptionColumns
Column Filter
Final CorrectedPosition Columns
Column Filter
ConvertHISPOSTMARAInteger to String
Number to String
Combineref_position_descriptionwith Correction
Concatenate
HISPOSTMARA
DB Table Selector
ConvertHISPOSTMARANumber to Integer
Double to Integer
Truncateref_position_descriptionReload
DB SQL Executor
Raw HISPOSTMARA
DB Reader
Removeduplicateposition_code
Duplicate Row Filter
CleanHISPOSTMARANumeric StringColumns
String Manipulation (Multi Column)
Add emptyjpa_code
Constant Value Column Appender
StatusPM_START_DATE
Rule Engine
Reloadref_position_description
DB Writer
Clean PM_SCALE
String Manipulation
Raw JAWATAN
DB Reader
PreparePM_START_DATEParse Value
Rule Engine
JAWATAN
DB Table Selector
StatusPM_END_DATE
Rule Engine
ParsePM_START_DATE
String to Date&Time
PreparePM_END_DATEParse Value
Rule Engine
rename columnPM_START_DATE_PARSE
Column Renamer
rename columnPM_END_DATE_PARSE
Column Renamer
ParsePM_END_DATE
String to Date&Time
StatisticHISPOSTMARAStatus
GroupBy
ValidateHISPOSTMARA
Rule Engine
Filter ValidHISPOSTMARA
Rule-based Row Filter
StatisticHISPOSTMARAPM_SCALE
GroupBy
RenameHISPOSTMARAfor F
Column Renamer
Rename RawJAWATAN Columns
Column Renamer
Select CleanHISPOSTMARAColumns
Column Filter
Convert Integerto String
Number to String
ConvertNumberto Integer
Double to Integer
CLEANED DB
Microsoft SQL Server Connector
Clean NumericString Columns
String Manipulation (Multi Column)
Apply correction
Excel Reader
Corrected join
Joiner
Insert F HISPOSTMARA
DB Writer
bank_code_final
Rule Engine
Truncate F HISPOSTMARA
DB SQL Executor
Clean POST_REF
String Manipulation
Read F HISPOSTMARA
DB Reader
Clean POST_STA
String Manipulation
Table F HISPOSTMARA
DB Table Selector
bank_status_final
Rule Engine
StatusDATE_CONFIRMED
Rule Engine
Create HISPOSTMARASource Key
String Manipulation
final_status
GroupBy
StatusJ_STARTDATE
Rule Engine
RenameHISPOSTMARAfor NORMALIZED
Column Renamer
bank_desc_final
Rule Engine
rename toJ_STARTDATE_DT
Column Renamer
Tablestaff_master
DB Table Selector
selected column
Column Filter
ParseJ_STARTDATEDate
String to Date&Time
LookupHISPOSTMARAStaff Master
Joiner
Clean EMPMAS BANK_CODE
String Manipulation
rename toDATE_CONFIRMED_DT
Column Renamer
NORMALIZED DB
Microsoft SQL Server Connector
EMPMAS BANK_CODE not empty
Rule-based Row Filter
ParseDATE_CONFIRMEDDate
String to Date&Time
Readstaff_master
DB Reader
Table EMPMAS
DB Table Selector
Filter ValidJAWATAN
Rule-based Row Filter
Raw EMPMAS
DB Reader
Validate JAWATAN
Rule Engine
StatusHISPOSTMARAStaff Lookup
Rule Engine
Distinct EMPMAS BANK_CODE
Column Renamer
Select CleanJAWATAN Columns
Column Filter
Readref_post_master
DB Reader
BANKCODE final valid only
Rule-based Row Filter
LookupHISPOSTMARAPost Master
Joiner
DB Writer
StatusHISPOSTMARAPost Master Lookup
Rule Engine
GroupBy
RenameJAWATAN for F
Column Renamer
Tableref_post_master
DB Table Selector
Missing BANKCODE reference from EMPMAS
Rule-based Row Filter
CLEANED DB
Microsoft SQL Server Connector
Tableref_position_description
DB Table Selector
PROPOSED_BANK_DESC
Constant Value Column Appender
truncate table
Text View
LookupHISPOSTMARAPosition Description
Joiner
BANKCODE final reference
Column Filter
Statistic POST_STA
GroupBy
StatusHISPOSTMARAPosition Lookup
Rule Engine
Check EMPMAS BANK_CODE vs BANKCODE
Joiner
Statistic JAWATAN Status
GroupBy
Readref_position_description
DB Reader
Load EMPMAS missing bank correction
Excel Reader
StatisticNO_GAJIPost Count
GroupBy
Statistic POST_REF
GroupBy
FinalHISPOSTMARANormalized Columns
Column Filter
ACTION REMARK
Constant Value Column Appender
Excel Writer
Filter NO_GAJIMultiple Post
Rule-based Row Filter
Export InvalidJAWATAN Records
Excel Writer
Filter InvalidJAWATAN
Rule-based Row Filter
Table F JAWATAN
DB Table Selector
CLEANED DB
Microsoft SQL Server Connector
RenameJAWATAN forNORMALIZED
Column Renamer
Read F JAWATAN
DB Reader
Tablestaff_master
DB Table Selector
SelectNORMALIZEDJAWATAN Columns
Column Filter
Readstaff_master
DB Reader
NORMALIZED DB
Microsoft SQL Server Connector
staff_mastersalary_no reference
Column Filter
StatusJAWATAN StaffLookup
Rule Engine
Issues list
Rule-based Row Filter
Check JAWATANsalary_no vsstaff_master
Joiner
ValidateNORMALIZEDJAWATAN
Rule Engine
Set PositionLookup NotValidated
Constant Value Column Appender
Cleaned Column
Column Filter
Rename statusforstaff_position_assignment
Column Renamer
Rename column
Column Renamer
Selectstaff_position_assignment Columns
Column Filter
Export Issue
Excel Writer
Insertstaff_position_assignment
DB Writer
VALID only
Rule-based Row Filter
Truncatestaff_position_assignment
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
check
Text View
StatisticNORMALIZED JAWATAN
GroupBy
Check duplicate codes
Duplicate Row Filter
Insert to Cleansing DB
DB Writer
Clean DEP_NAME
String Manipulation
Clean DEP_IC_BC
String Manipulation
RenameCorrectedSchemeColumns
Column Renamer
Clean DEPENDENTSNumeric StringColumns
String Manipulation (Multi Column)
CleanRELATIONSHIP
String Manipulation
Final CorrectedScheme Columns
Column Filter
CleanDEP_LAYAKTAX
String Manipulation
SelectCorrectedScheme Columns
Column Filter
Addempty jpa_code
Constant Value Column Appender
Clean DEP_HEALTH
String Manipulation
Combineref_service_schemewith Correction
Concatenate
CleanDEP_BELAJAR
String Manipulation
Addcorrectionetl_status
Constant Value Column Appender
Addempty grade_scheme
Constant Value Column Appender
Combineref_service_schemewith Correction
Concatenate
Originalref_service_schemeColumns
Column Filter
Convert DEPENDENTSInteger to String
Number to String
Removeduplicateservice_scheme_code
Duplicate Row Filter
Handle MissingDEPENDENTS NumericString Columns
Missing Value
Convert DEPENDENTSNumber to Integer
Double to Integer
Filter Valid OLDPOST
Rule-based Row Filter
Table FOLDPOST
DB Table Selector
Truncate F OLDPOST
DB SQL Executor
Reloadref_service_scheme
DB Writer
Read FOLDPOST
DB Reader
Truncateref_service_scheme
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
POSTDESC
DB Table Selector
DEPENDENTS
DB Table Selector
Raw POSTDESC
DB Reader
Rename RawDEPENDENTS Columns
Column Renamer
Clean POST_DESC
String Manipulation
Insert F OLDPOST
DB Writer
Clean POST_CODE
String Manipulation
Raw DEPENDENTS
DB Reader
StatisticPOSTDESC Status
GroupBy
Validate POSTDESC
Rule Engine
FilterDuplicatePOST_CODE
Rule-based Row Filter
StatisticDuplicatePOST_CODE
GroupBy
Select CleanOLDPOST Columns
Column Filter
RenameOLDPOST for F
Column Renamer
ExportDuplicatePOST_CODE
Excel Writer
Truncate F DEPENDENTS
DB SQL Executor
Table FDEPENDENTS
DB Table Selector
Select CleanPOSTDESCColumns
Column Filter
Select CleanDEPENDENTS Columns
Column Filter
FilterValid POSTDESC
Rule-based Row Filter
RenameDEPENDENTS for F
Column Renamer
CLEANED DB
Microsoft SQL Server Connector
RenamePOSTDESC for F
Column Renamer
Insert F POSTDESC
DB Writer
CLEANED DB
Microsoft SQL Server Connector
TruncateF POSTDESC
DB SQL Executor
ReadF POSTDESC
DB Reader
Table F POSTDESC
DB Table Selector
Filter DuplicateDEPENDENTS
Rule-based Row Filter
Clean KOD_JPA
String Manipulation
Export InvalidDEPENDENTS Records
Excel Writer
Filter ValidDEPENDENTS
Rule-based Row Filter
Export duplicate
Excel Writer
Filter InvalidDEPENDENTS
Rule-based Row Filter
StatisticF POSTDESC
GroupBy
StatisticDEPENDENTS Relationship
GroupBy
Statistic KOD_JPA
GroupBy
StatisticDEP_BELAJAR
GroupBy
SelectNORMALIZEDPOSTDESC Columns
Column Filter
Validate DEPENDENTS
Rule Engine
RenamePOSTDESC forNORMALIZED
Column Renamer
StatisticDEPENDENTS Status
GroupBy
NORMALIZED DB
Microsoft SQL Server Connector
Truncateref_position_description
DB SQL Executor
Tablestaff_service
DB Table Selector
StatisticDEP_LAYAKTAX
GroupBy
Insertref_position_description
DB Writer
DuplicateDEPENDENTS Check
GroupBy
Tableref_position_description
DB Table Selector
Read staff_service
DB Reader
Parse EP_BIRTHDATE
String to Date&Time
ParseDEP_BIRTHDATE
Column Renamer
StatusDEP_BIRTHDATE
Rule Engine
PrepareDEP_BIRTHDATEParse Value
Rule Engine
Statistic SPOUSE Status
GroupBy
Status SI_TAX
Rule Engine
Validate SPOUSE
Rule Engine
Clean SPOUSEAddress Columns
String Manipulation (Multi Column)
Clean SI_TEL
String Manipulation
Clean SI_COMPANY
String Manipulation
Clean SI_POSKOD
String Manipulation
Status SI_POSKOD
Rule Engine
Clean SI_TAX
String Manipulation
Clean SPOUSEFlag Columns
String Manipulation (Multi Column)
CleanSPOUSE NO_GAJI
String Manipulation
Clean SI_NAME
String Manipulation
Convert SPOUSEInteger to String
Number to String
Handle MissingSPOUSE NumericString Columns
Missing Value
Read FDEPENDENTS
DB Reader
Insert FDEPENDENTS
DB Writer
Rename RawSPOUSE Columns
Column Renamer
Convert SPOUSENumber to Integer
Double to Integer
SPOUSE
DB Table Selector
Raw SPOUSE
DB Reader
Filter Valid SPOUSE
Rule-based Row Filter
CLEANED DB
Microsoft SQL Server Connector
Table FSPOUSE
DB Table Selector
Select CleanSPOUSE Columns
Column Filter
Rename SPOUSE for F
Column Renamer
Insert F SPOUSE
DB Writer
Truncate F SPOUSE
DB SQL Executor
Read FSPOUSE
DB Reader
Export InvalidSPOUSE Records
Excel Writer
Export MultipleSPOUSE by Staff
Excel Writer
StatisticSI_TAX Status
GroupBy
Count SPOUSEby NO_GAJI
GroupBy
Statistic SI_KERJA
GroupBy
StatisticSI_POSKOD Status
GroupBy
Filter DuplicateSPOUSE Exact
Rule-based Row Filter
Filter Invalid SPOUSE
Rule-based Row Filter
Filter MultipleSPOUSE by Staff
Rule-based Row Filter
Duplicate SPOUSEExact Check
GroupBy
Clean NOTAXNumeric DateColumns
String Manipulation (Multi Column)
Handle MissingNOTAX NumericString Columns
Missing Value
StatusTAX_AKHIR
Rule Engine
StatusTAX_MULA
Rule Engine
PrepareTAX_AKHIRParse Value
Rule Engine
PrepareTAX_MULAParse Value
Rule Engine
Rename toTAX_MULA_PARSED
Column Renamer
ParseTAX_MULA
String to Date&Time
Rename toTAX_AKHIR_PARSED
Column Renamer
ParseTAX_AKHIR
String to Date&Time
ValidateNOTAX
Rule Engine
FilterInvalid NOTAX
Rule-based Row Filter
StatisticNOTAX Status
GroupBy
FilterValid NOTAX
Rule-based Row Filter
Export InvalidNOTAX Records
Excel Writer
RenameNOTAX for F
Column Renamer
Select CleanNOTAX Columns
Column Filter
Truncate F NOTAX
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
Read F NOTAX
DB Reader
Insert F NOTAX
DB Writer
Table F NOTAX
DB Table Selector
Raw Q_LEVEL
DB Reader
Q_LEVEL
DB Table Selector
Convert Q_LEVELInteger to String
Number to String
Convert Q_LEVELNumber to Integer
Double to Integer
Clean QLEV_ABBR
String Manipulation
Clean QLEV_KOD
String Manipulation
Validate Q_LEVEL
Rule Engine
Clean QLEV_DESC
String Manipulation
StatisticQ_LEVEL Status
GroupBy
Filter DuplicateQLEV_KOD
Rule-based Row Filter
DuplicateCheck QLEV_KOD
GroupBy
Read F ELNMAS
DB Reader
Select CleanBINTANG Columns
Column Filter
Truncate F ELNMAS
DB SQL Executor
Export Invalid
Excel Writer
Insert F ELNMAS
DB Writer
CLEANED DB
Microsoft SQL Server Connector
Table F ELNMAS
DB Table Selector
Rename BINTANG for F
Column Renamer
DEDMAS
DB Table Selector
Truncate F BINTANG
DB SQL Executor
Raw DEDMAS
DB Reader
Table FBINTANG
DB Table Selector
Convert DEDMASInteger to String
Number to String
Convert DEDMASNumber to Integer
Double to Integer
Read FBINTANG
DB Reader
Clean DED_KOD
String Manipulation
Raw PREVPOST
DB Reader
Insert F BINTANG
DB Writer
CleanDED_SLIP_DESC
String Manipulation
Convert PREVPOSTNumber to Integer
Double to Integer
Clean DED_DESC
String Manipulation
PREVPOST
DB Table Selector
Validate DEDMAS
Rule Engine
Handle MissingPREVPOST NumericString Columns
Missing Value
Clean DEDMASFlag and GLColumns
String Manipulation (Multi Column)
Convert PREVPOSTInteger to String
Number to String
Check DuplicateDED_KOD
GroupBy
CleanPPOST_STATUS
String Manipulation
StatisticDEDMAS Status
GroupBy
Clean PREVPOSTNumeric StringColumns
String Manipulation (Multi Column)
Filter InvalidDEDMAS
Rule-based Row Filter
Filter DuplicateDED_KOD
Rule-based Row Filter
Clean PPOST_REF
String Manipulation
Export InvalidDEDMAS Records
Excel Writer
Status PPOST_END
Rule Engine
StatusPPOST_START
Rule Engine
Select CleanDEDMAS Columns
Column Filter
Prepare PPOST_ENDParse Value
Rule Engine
Filter ValidDEDMAS
Rule-based Row Filter
PreparePPOST_STARTParse Value
Rule Engine
Truncate F DEDMAS
DB SQL Executor
RenamePPOST_START_DATE
Column Renamer
RenameDEDMAS for F
Column Renamer
Parse PPOST_START
String to Date&Time
Table F DEDMAS
DB Table Selector
RenamePPOST_END_DATE
Column Renamer
CLEANED DB
Microsoft SQL Server Connector
Parse PPOST_END
String to Date&Time
Insert F DEDMAS
DB Writer
StatisticPREVPOST Status
GroupBy
Read F DEDMAS
DB Reader
Validate PREVPOST
Rule Engine
DEDUCTION
DB Table Selector
Raw DEDUCTION
DB Reader
StatisticPPOST_STATUS
GroupBy
Rename RawDEDUCTION Columns
Column Renamer
DuplicateCheck PREVPOST
GroupBy
StatisticPPOST_REF
GroupBy
Truncate staff_service_history
DB SQL Executor
Convert DEDUCTIONInteger to String
Number to String
Export duplicate
Excel Writer
Convert DEDUCTIONNumber to Integer
Double to Integer
Filter DuplicatePREVPOST
Rule-based Row Filter
URUSAN
DB Table Selector
Clean DEDUCTIONNumeric StringColumns
String Manipulation (Multi Column)
Export InvalidPREVPOST Records
Excel Writer
Insertstaff_service_history
DB Writer
Handle MissingDEDUCTIONNumeric StringColumns
Missing Value
Filter InvalidPREVPOST
Rule-based Row Filter
ConvertURUSANNumber to Integer
Double to Integer
Clean DED_REF
String Manipulation
Select CleanPREVPOST Columns
Column Filter
Raw URUSAN
DB Reader
Clean DED_TYPE
String Manipulation
Filter ValidPREVPOST
Rule-based Row Filter
Clean URUSAN
String Manipulation
Status END_DATE
Rule Engine
ConvertURUSANInteger to String
Number to String
StatusSTART_DATE
Rule Engine
RenamePREVPOST for F
Column Renamer
Validate URUSAN
Rule Engine
Clean URUS_DESC
String Manipulation
PrepareSTART_DATEParse Value
Rule Engine
StatisticURUSAN Status
GroupBy
Table FPREVPOST
DB Table Selector
Read FPREVPOST
DB Reader
Parse START_DATE
String to Date&Time
Truncate F PREVPOST
DB SQL Executor
PrepareEND_DATEParse Value
Rule Engine
CLEANED DB
Microsoft SQL Server Connector
FilterDuplicateURUSAN
Rule-based Row Filter
Parse END_DATE
String to Date&Time
OLDPOST
DB Table Selector
StatisticDuplicateURUSAN
GroupBy
Rename toSTART_DATE
Column Renamer
Insert F PREVPOST
DB Writer
Filter ValidURUSAN
Rule-based Row Filter
Validate DEDUCTION
Rule Engine
Convert OLDPOSTNumber to Integer
Double to Integer
ExportDuplicateURUSAN
Excel Writer
Rename toEND_DATE_PARSED
Column Renamer
Raw OLDPOST
DB Reader
RenameURUSAN for F
Column Renamer
Statistic DED_TYPE
GroupBy
Handle MissingOLDPOST NumericString Columns
Missing Value
Select CleanURUSAN Columns
Column Filter
StatisticDEDUCTION Status
GroupBy
Convert OLDPOSTInteger to String
Number to String
Truncate F URUSAN
DB SQL Executor
Filter InvalidDEDUCTION
Rule-based Row Filter
CLEANED DB
Microsoft SQL Server Connector
Statistic DED_KOD
GroupBy
Raw SCALESSM_D
DB Reader
Insert F URUSAN
DB Writer
Export InvalidDEDUCTION Records
Excel Writer
SCALESSM_D
DB Table Selector
Select CleanDEDUCTION Columns
Column Filter
Filter ValidDEDUCTION
Rule-based Row Filter
ValidateSCALESSM_D
Rule Engine
CLEANED DB
Microsoft SQL Server Connector
Clean SSM_KOD_GRED
String Manipulation
RenameDEDUCTION for F
Column Renamer
Statistic DuplicateGred Tangga
GroupBy
Read F DEDUCTION
DB Reader
StatisticSCALESSM_DStatus
GroupBy
Truncate F DEDUCTION
DB SQL Executor
Filter ValidSCALESSM_D
Rule-based Row Filter
Insert FDEDUCTION
DB Writer
Filter DuplicateGred Tangga
Rule-based Row Filter
Table F DEDUCTION
DB Table Selector
RenameSCALESSM_Dfor F
Column Renamer
Select CleanSCALESSM_DColumns
Column Filter
Raw DEDACCNT
DB Reader
CLEANED DB
Microsoft SQL Server Connector
Convert DEDACCNTNumber to Integer
Double to Integer
DEDACCNT
DB Table Selector
Insert F SCALESSM_D
DB Writer
Handle MissingDEDACCNTNumeric StringColumns
Missing Value
Truncate F SCALESSM_D
DB SQL Executor
Convert DEDACCNTInteger to String
Number to String
SCALESSM_M
DB Table Selector
CleanAKAUN_PTGN
String Manipulation
Raw SCALESSM_M
DB Reader
Clean DEDACCNTNumeric StringColumns
String Manipulation (Multi Column)
CleanSSM_KOD_DESC
String Manipulation
CleanFILLER_PTGN
String Manipulation
CleanSSM_KOD_GRED
String Manipulation
CleanSTATUS_PTGN
String Manipulation
ConvertSCALESSM_MNumber to Integer
Double to Integer
Prepare TKH_UPDParse Value
Rule Engine
Clean otherstring column
String Manipulation (Multi Column)
Status TKH_UPD
Rule Engine
CleanSCALESSM_MNumeric StringColumns
String Manipulation (Multi Column)
ConvertSCALESSM_MInteger to String
Number to String
Parse TKH_UPD
String to Date&Time
Status SSM_DATE
Rule Engine
StatisticDEDACCNT Status
GroupBy
Validate DEDACCNT
Rule Engine
StatisticPOSTMASPOST_STA
GroupBy
Parse SSM_DATE
String to Date&Time
Check DuplicateDEDACCNT Account
GroupBy
PrepareSSM_DATEParse Value
Rule Engine
StatisticSTATUS_PTGN
GroupBy
StatisticPOSTMAS P_SKIM
GroupBy
ValidateSCALESSM_M
Rule Engine
Filter InvalidDEDACCNT
Rule-based Row Filter
Excel Writer
rename toSSM_DATE_PARSED
Column Renamer
Filter DuplicateDEDACCNT Account
Rule-based Row Filter
Statistic DuplicatePOST_NO
GroupBy
StatisticDuplicateSSM_KOD_GRED
GroupBy
Filter ValidDEDACCNT
Rule-based Row Filter
Excel Writer
StatisticSCALESSM_MStatus
GroupBy
Export InvalidDEDACCNT Records
Excel Writer
Excel Writer
Filter ValidSCALESSM_M
Rule-based Row Filter
Filter DuplicatePOST_NO
Rule-based Row Filter
FilterDuplicateSSM_KOD_GRED
Rule-based Row Filter
Select CleanDEDACCNT Columns
Column Filter
Select CleanPOSTMAS Columns
Column Filter
FilterValid POSTMAS
Rule-based Row Filter
Select CleanSCALESSM_MColumns
Column Filter
RenamePOSTMAS for F
Column Renamer
Truncate F DEDACCNT
DB SQL Executor
RenameDEDACCNT for F
Column Renamer
CLEANED DB
Microsoft SQL Server Connector
Table F DEDACCNT
DB Table Selector
RenameSCALESSM_Mfor F
Column Renamer
CLEANED DB
Microsoft SQL Server Connector
CLEANED DB
Microsoft SQL Server Connector
InsertF SCALESSM_M
DB Writer
Insert F DEDACCNT
DB Writer
Truncate FPOSTMAS
DB SQL Executor
Truncate F SCALESSM_M
DB SQL Executor
Read F DEDACCNT
DB Reader
Table F POSTMAS
DB Table Selector
Raw KELAYAKAN
DB Reader
Raw NOTAX
DB Reader
Insert F POSTMAS
DB Writer
KELAYAKAN
DB Table Selector
NOTAX
DB Table Selector
Rename POSTMASfor NORMALIZED
Column Renamer
Convert KELAYAKANInteger to String
Number to String
Convert NOTAXInteger to String
Number to String
Read F POSTMAS
DB Reader
ConvertKELAYAKANNumber to Integer
Double to Integer
Convert NOTAXNumber to Integer
Double to Integer
NORMALIZED DB
Microsoft SQL Server Connector
ValidateKELAYAKAN
Rule Engine
Create POSTMASsource_key
Rule Engine
Clean KELAYAKANNumeric StringColumns
String Manipulation (Multi Column)
Select NORMALIZEDPOSTMAS Columns
Column Filter
StatisticKELAYAKAN Status
GroupBy
Truncateref_post_master
DB SQL Executor
StatisticDuplicateKELAYAKAN
GroupBy
Export KELAYAKANStatus Statistic
Excel Writer
Read F JAWATAN
DB Reader
Export DuplicateKELAYAKAN
Excel Writer
Insertref_post_master
DB Writer
Filter DuplicateKELAYAKAN
Rule-based Row Filter
CLEANED DB
Microsoft SQL Server Connector
Filter InvalidKELAYAKAN
Rule-based Row Filter
JAWATAN
DB Table Selector
Filter ValidKELAYAKAN
Rule-based Row Filter
Filter JAWATANPOST_NONot Empty
Rule-based Row Filter
Select CleanKELAYAKANColumns
Column Filter
CleanJAWATAN POST_NO
String Manipulation
Export InvalidKELAYAKANRecords
Excel Writer
NORMALIZED DB
Microsoft SQL Server Connector
DistinctJAWATAN POST_NO
GroupBy
RenameKELAYAKANfor F
Column Renamer
Tableref_post_master
DB Table Selector
CLEANED DB
Microsoft SQL Server Connector
Truncate F KELAYAKAN
DB SQL Executor
POSTMASReference Columns
Column Filter
Table F KELAYAKAN
DB Table Selector
Readref_post_master
DB Reader
Insert F KELAYAKAN
DB Writer
StatusPOSTMAS Lookup
Rule Engine
Statistic FKELAYAKAN Status
GroupBy
CheckJAWATAN POST_NOvs POSTMAS
Joiner
Read F KELAYAKAN
DB Reader
Export POSTMASLookup Statistic
Excel Writer
EDUMAS
DB Table Selector
StatisticPOSTMAS Lookup
GroupBy
Raw EDUMAS
DB Reader
Add MissingPOSTMAS IssueAction
Rule Engine
Convert EDUMASInteger to String
Number to String
Filter MissingPOSTMAS Reference
Rule-based Row Filter
Convert EDUMASNumber to Integer
Double to Integer
Missing POSTMASReference Columns
Column Filter
Add CorrectedPOST_NO Column
Constant Value Column Appender
Clean EDU_KOD
String Manipulation
Export MissingPOSTMAS Reference
Excel Writer
Clean EDU_DESC
String Manipulation
Clean EDU_ABBR
String Manipulation
Check data
Column Filter
Filter CorrectedPOSTMAS Reference
Rule-based Row Filter
Statisti EDUMAS Status
GroupBy
Load MissingPOSTMAS Correction
Excel Reader
Validate EDUMAS
Rule Engine
CleanMARITAL_ST
String Manipulation
ValidatePOSTMASCorrection
Rule Engine
Filter DuplicateEDU_KOD
Rule-based Row Filter
Datatype to Int
Double to Integer
Create POSTMASpost_no_final
Rule Engine
StatisticDuplicate EDU_KOD
GroupBy
StatusMARITAL_ST
Rule Engine
StatusProposedCRET_DATE
Rule Engine
Select CleanEDUMAS Columns
Column Filter
Filter ValidPOSTMAS Correction
Rule-based Row Filter
Filter ValidEDUMAS
Rule-based Row Filter
Status phone
Rule Engine
Select CorrectedPOSTMAS Columns
Column Filter
Clean TEL_NO
String Manipulation
Parse ProposedCRET_DATE
String to Date&Time
RenameEDUMAS for F
Column Renamer
StatisticMARITAL_ST
GroupBy
Addleading zero
String Manipulation
Rename CorrectedPOSTMAS Columns
Column Renamer
StatistikPhone
GroupBy
Truncate F EDUMAS
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
Add POSTMASsource_system
Constant Value Column Appender
Table F EDUMAS
DB Table Selector
Create CorrectedPOSTMAS source_key
Rule Engine
Insert F EDUMAS
DB Writer
OverallEMPMAS Validation
Rule Engine
Statistic F EDUMAS
GroupBy
Statistik kontrek
GroupBy
Final CorrectedPOSTMAS Columns
Column Filter
Read F EDUMAS
DB Reader
FilterREADY_FOR_F EMPMAS
Rule-based Row Filter
Readref_post_master
DB Reader
INVALID_RECORDS
Excel Writer
StatisticOverall EMPMAS
GroupBy
Filter Invalid EDUMAS
Rule-based Row Filter
FinalEMPMAS FColumns
Column Filter
Tableref_post_master
DB Table Selector
Raw WARIS
DB Reader
FilterEMPMAS Issue List
Rule-based Row Filter
NORMALIZED DB
Microsoft SQL Server Connector
WARIS
DB Table Selector
DB Writer
Combineref_post_masterwith Correction
Concatenate
RenameEMPMAS FColumns
Column Renamer
Originalref_post_masterColumns
Column Filter
SKIMMAS
DB Table Selector
CLEANED DB
Microsoft SQL Server Connector
Remove DuplicatePOSTMAS post_no
Duplicate Row Filter
Raw SKIMMAS
DB Reader
Reloadref_post_master
DB Writer
Truncateref_post_master
DB SQL Executor
CleanSKIM_DESC
String Manipulation
Raw POSTHISTORY
DB Reader
CleanKOD_SKIM
String Manipulation
POSTHISTORY
DB Table Selector
CleanGRED_SKIM
String Manipulation
Rename RawPOSTHISTORYColumns
Column Renamer
CleanSKIM_JPA
String Manipulation
ConvertPOSTHISTORYNumber to Integer
Double to Integer
StatisticSKIMMAS Status
GroupBy
ConvertPOSTHISTORYInteger to String
Number to String
ValidateSKIMMAS
Rule Engine
Clean POSTHISTORYNumeric String Columns
String Manipulation (Multi Column)
FilterDuplicateKOD_SKIM
Rule-based Row Filter
StatisticDuplicate KODSKIM
GroupBy
Clean POST_STA
String Manipulation
Filter ValidSKIMMAS
Rule-based Row Filter
Clean POST_REF
String Manipulation
Clean POST_KJ
String Manipulation
Column Filter
StatusJ_ENDATE
Rule Engine
RenameSKIMMAS for F
Column Renamer
Status TARIKH_MULA
Rule Engine
Insert FSKIMMAS
DB Writer
Rename TARIKH_MULA_DT
Column Renamer
Final FSKIMMASColumns
Column Filter
ParseTARIKH_MULA Date
String to Date&Time
SKIMMAS
DB Table Selector
Rename J_ENDATE_DT
Column Renamer
CLEANED DB
Microsoft SQL Server Connector
ParseTARIKH_MULA Date
String to Date&Time
Read FSKIMMAS
DB Reader
Statistic POSTHISTORYStatus
GroupBy
RenameSKIMMAS to ref_service_scheme
Column Renamer
ValidatePOSTHISTORY
Rule Engine
Insertref_service_scheme
DB Writer
Finalref_service_schemeColumns
Column Filter
StatisticOLDPOST Status
GroupBy
Duplicate CheckOLDPOST Code
GroupBy
StatisticPOSTHISTORYPOST_STA
GroupBy
CleanOPOST_DESC
String Manipulation
Validate OLDPOST
Rule Engine
NORMALIZED DB
Microsoft SQL Server Connector
StatisticPOSTHISTORYPOST_REF
GroupBy
Filter InvalidOLDPOST
Rule-based Row Filter
StatisticPOSTHISTORYPOST_KJ
GroupBy
Export InvalidOLDPOST Records
Excel Writer
staff_service
DB Table Selector
Filter InvalidPOSTHISTORY
Rule-based Row Filter
Filter DuplicateOLDPOST Code
Rule-based Row Filter
DB SQL Executor
Filter ValidPOSTHISTORY
Rule-based Row Filter
Export duplicate
Excel Writer
Readref_service_scheme
DB Reader
Select CleanPOSTHISTORY Columns
Column Filter
Read staff_service
DB Reader
Export InvalidPOSTHISTORYRecords
Excel Writer
Checkstaff_service vsSKIMMAS
Joiner
Truncate FPOSTHISTORY
DB SQL Executor
ref_service_scheme
DB Table Selector
RenamePOSTHISTORYfor F
Column Renamer
StatisticService SchemeLookup
GroupBy
StatusService SchemeLookup
Rule Engine
CLEANED DB
Microsoft SQL Server Connector
CleanOPOST_KOD
String Manipulation
Filter MissingService Scheme
Rule-based Row Filter
Table FPOSTHISTORY
DB Table Selector
Insert FPOSTHISTORY
DB Writer
PROPOSED_SCHEME_DESC
Constant Value Column Appender
RenamePOSTHISTORYfor NORMALIZED
Column Renamer
Missing ServiceScheme Summary
GroupBy
Read FPOSTHISTORY
DB Reader
Excel Writer
LookupPOSTHISTORYStaff Master
Joiner
ACTION_REMARK
Constant Value Column Appender
CreatePOSTHISTORYsource_key
String Manipulation
Filter CorrectedService Scheme
Rule-based Row Filter
NORMALIZED DB
Microsoft SQL Server Connector
Load MissingService SchemeCorrection
Excel Reader
Tablestaff_master
DB Table Selector
Create ServiceScheme DescFinal
Rule Engine
StatusPOSTHISTORYStaff Lookup
Rule Engine
Create ServiceScheme CodeFinal
Rule Engine
Read NORMALIZED_HRstaff_master
DB Reader
Filter ValidService SchemeCorrection
Rule-based Row Filter
Validate CorrectedService Scheme
Rule Engine
POSTMAS
DB Table Selector
Raw POSTMAS
DB Reader
Convert POSTMASNumber to Integer
Double to Integer
Rename RawPOSTMAS Columns
Column Renamer
Clean POSTMASNumeric String Columns
String Manipulation (Multi Column)
Convert POSTMASInteger to String
Number to String
Clean P_SKIM
String Manipulation
Clean J_SCALE
String Manipulation
Clean P_QTRS
String Manipulation
Clean POST_STA
String Manipulation
Postcode fr ADRS4
String Manipulation
Clean GRED_JKK
String Manipulation
Remove extra column
Column Filter
Filter ValidCRET_DATE For Parse
Rule-based Row Filter
Capture Postcode
Rule Engine
Status CRET_DATE
Rule Engine
EMPMAS
DB Table Selector
Filter CRET_DATE No Date
Rule-based Row Filter
Color Manager
ParseCRET_DATEDate
String to Date&Time
Define Statistic
Rule Engine
CombineCRET_DATEDate Branch
Concatenate
Statistic
GroupBy
Add EmptyCRET_DATE Date
Constant Value Column Appender
Remove trailing spaces
String Manipulation (Multi Column)
StatisticPOSTMAS Status
GroupBy
Validate POSTMAS
Rule Engine
DB Reader
Chart
Pie Chart
Excel Writer
Create missingBANK_DESC_FINAL
Rule Engine
Validate missingbank correction
Rule Engine
Corrected missingreference only
Rule-based Row Filter
Create missingBANK_CODE_FINAL
Rule Engine
Branch Bfinal columns
Column Filter
Combine BranchA and B BANKCODE
Concatenate
Valid Branch Bcorrection only
Rule-based Row Filter
Branch Afinal columns
Column Filter
Rename final BANKCODE columns
Column Renamer
Remove duplicateBANK_CODE
Duplicate Row Filter
Statistic
GroupBy
CLEANED DB
Microsoft SQL Server Connector
Final valid BANKCODE only
Rule-based Row Filter
FINAL_LOAD_STATUS
Rule Engine
Insert to Cleansing DB
DB Writer
Final BANKCODEcolumns for F
Column Filter
Column Filter
Date column to clean
Metanode
Postcode fr ADRS3
String Manipulation
Int to String
Number to String
Add padleft 0
String Manipulation
Postcode fr ADRS2
String Manipulation
Remove space empty
String Manipulation (Multi Column)
Statistics
Metanode
Check akhir < mula kontrek
Rule Engine
Convert to date
String to Date&Time
Column Filter Widget
Excel Writer
Value Counter
SOURCE: SHORTLIST
Microsoft SQL Server Connector
Table BANKCODE
DB Table Selector
Raw BANKCODE
DB Reader
Clean BANK_CODE
String Manipulation
BANKCODE NOTES
Text View
Clean BANK_DESC
String Manipulation
Filter ValidIKTISAS_M
Rule-based Row Filter
Export invalid
Excel Writer
Filter InvalidIKTISAS_M
Rule-based Row Filter
RenameIKTISAS_M for F
Column Renamer
Select CleanIKTISAS_MColumns
Column Filter
Table FIKTISAS_M
DB Table Selector
Truncate F IKTISAS_M
DB SQL Executor
CLEANED DB
Microsoft SQL Server Connector
Read FIKTISAS_M
DB Reader
Insert FIKTISAS_M
DB Writer
Status Validation
Rule Engine
Statistik
GroupBy
AHLI_IKTISAS
DB Table Selector
Raw AHLI_IKTISAS
DB Reader
ConvertAHLI_IKTISASInteger to String
Number to String
ConvertAHLI_IKTISASNumber to Integer
Double to Integer
Clean IKTISAS_CD
String Manipulation
Clean NO_GAJI
String Manipulation
StatisticAHLI_IKTISASStatus
GroupBy
ValidateAHLI_IKTISAS
Rule Engine
Filter DuplicateAHLI_IKTISAS
Rule-based Row Filter
DuplicateCheck AHLI_IKTISAS
GroupBy
Export duplicate
Excel Writer
Filter InvalidAHLI_IKTISAS
Rule-based Row Filter
Filter ValidAHLI_IKTISAS
Rule-based Row Filter
Select CleanAHLI_IKTISASColumns
Column Filter
Export invalid
Excel Writer
Add PendingIKTISAS LookupStatus
Constant Value Column Appender
RenameAHLI_IKTISAS for F
Column Renamer
Table FAHLI_IKTISAS
DB Table Selector
Read FAHLI_IKTISAS
DB Reader
CLEANED DB
Microsoft SQL Server Connector
Insert FAHLI_IKTISAS
DB Writer
Truncate F AHLI_IKTISAS
DB SQL Executor
BINTANG
DB Table Selector
Raw BINTANG
DB Reader
Convert BINTANGInteger to String
Number to String
Convert BINTANGNumber to Integer
Double to Integer
Clean BINTANGNumeric StringColumns
String Manipulation (Multi Column)
Handle MissingBINTANG NumericString Columns
Missing Value
Clean BTNG_DESC
String Manipulation
Clean BTNG_JENIS
String Manipulation
Status BTNG_DATE
Rule Engine
Clean ELN_EPF
String Manipulation
Filter ReadyBTNG_DATE
Rule-based Row Filter
PrepareBTNG_DATEParse Value
Rule Engine
Validate ELNMAS
Rule Engine
Rename toBTNG_DATE_PARSED
Column Renamer
Clean ELN_SOCSO
String Manipulation
Parse BTNG_DATE
String to Date&Time
DuplicateCheck ELN_KOD
GroupBy
Statistic BINTANGStatus
GroupBy
StatisticELNMAS Status
GroupBy
Validate BINTANG
Rule Engine
Filter InvalidELNMAS
Rule-based Row Filter
StatisticBTNG_DATE_STATUS
GroupBy
Filter DuplicateELN_KOD
Rule-based Row Filter
Statistic BTNG_JENIS
GroupBy
Filter ValidELNMAS
Rule-based Row Filter
Export InvalidELNMAS Records
Excel Writer
DuplicateCheck BINTANG
GroupBy
Select CleanELNMAS Columns
Column Filter
Export duplicate
Excel Writer
Filter DuplicateBINTANG
Rule-based Row Filter
CLEANED DB
Microsoft SQL Server Connector
Filter Invalid BINTANG
Rule-based Row Filter
RenameELNMAS for F
Column Renamer
Filter Valid BINTANG
Rule-based Row Filter

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-06-09
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!