Icon

Everest Severance

Join_Payroll fields
Concatenate
Total severance
Math Formula
USD Sev
Math Formula
Add_Payroll File field
Constant Value Column Appender
USD Sev + 3 months base salary USD
Math Formula
Add_Payroll File field
Constant Value Column Appender
Output
Excel Writer
3 Months Base Salary
Math Formula
3 months base salary USD
Math Formula
Join census & Payroll fields
Joiner
Add_Payroll File field
Constant Value Column Appender
Add_Payroll File field
Constant Value Column Appender
Combine EMP ID and Payroll Desc into columns for vlookup
Pivot
GroupBy
Number to String
Column Renamer
Add VIC + Monthly Base
Math Formula
Column Resorter
Missing Payroll Fields become 0's
Missing Value
Avg Mont Salary - cash award
Math Formula
Add total comp minus cash award
Math Formula
Total Comp + Cash Award
Math Formula
Lower Avg or 3x Avg
Rule Engine
Avg Mont Salary - cash award
Math Formula
Add 3x city average
Rule Engine
Beijing
Excel Reader
Shanghai
Excel Reader
SZ
Excel Reader
XA
Excel Reader
Only in scope payroll desc
Rule-based Row Filter
Only in scope payroll desc
Rule-based Row Filter
Only in scope payroll desc
Rule-based Row Filter
3x avg used?
Rule Engine
3x avg used?
Rule Engine
Lower Avg or 3x Avg
Rule Engine
GroupBy
difference between term and hire date
Date&Time Difference
Years of Servce
Math Formula
Add _ Assumed Term Date
Constant Value Column Appender
Add _ Svc Hire Date
Rule Engine
Years of Service ROunded
Math Formula
YOS cap at 12
Rule Engine
Pull Hire Date < 2008
Rule-based Row Filter
GroupBy
Diff_2008 and Hire
Date&Time Difference
Post 2008 Sev
Math Formula
Pre 2008 severance
Math Formula
Only in scope payroll desc
Rule-based Row Filter
Group by Emp ID & Sum Value field
GroupBy
YOS rounded
Math Formula
GroupBy
Group by Emp ID & Sum Value field
GroupBy
Add LOS 2008
Joiner
GroupBy
2008 Date
Constant Value Column Appender
GroupBy
YoS w/ 2008
Math Formula
EVEREST CENSUS
Excel Reader
Column Filter
Group by Emp ID & Sum Value field
GroupBy
0's if no LOS 2008
Rule Engine
Group by Emp ID & Sum Value field
GroupBy

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: SamHopkins
Created at: 2026-02-24
On NodePit since: 2026-02-25
Last update: 2026-02-25
Created with KNIME version: v5.9.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!