Icon

S5-05-Accuracy

HRIS dataset
Excel Reader
Payroll Dataset
Excel Reader
Validate national IDs from two departments
Joiner
Create accuracy rules per row. (4 rules)
Expression
Split records into Accuracy(Violation count=0) and Inaccuracy(Violation count>0).
Row Splitter
Preview inacculate records for correction
Table View
Keep only original columns
Column Filter
Finance summary
Excel Reader
Export accurate dataset
Excel Writer
Calculate payroll difference
Expression
Case summary
GroupBy
Descendingpayroll difference %
Sorter
Group: dept_code, pay_peroidAggregation: SUM(pay_amount)
GroupBy
Attach total payroll by dept_code and pay_period
Joiner
Export finance error data
Excel Writer

Nodes

Extensions

Links