Icon

Full Solution II

Read all Employees Data,remove column "Country"Read Department mappingrename First(Department) to "Department)Perform LookupJob Title to DepartmentDecide if Employee isActive or InactiveSort NamesRemove "-" from Employee IDSeparateactivefrominactiveConvert String toDate and timecalculate time of employmentfrom start till todaycalculate time of employmentfrom start to endconcatenatetable together- Remove column "id"- First_name to FirstName-Last_name to LastName-LastName befor FirstNameConnect toCustomerData.sqliteSelectTable"Countries"Join on EmployeeID with countriesvalidate dataLoad templateLoad data to DBCSV Reader Excel Reader Cell Replacer Rule Engine Sorter String Manipulation Row Splitter String to Date&Time Date&TimeDifference Date&TimeDifference Concatenate Table Manipulator SQLite Connector DB Table Selector DB Reader Joiner Table Validator(Reference) CSV Reader DB Writer Read all Employees Data,remove column "Country"Read Department mappingrename First(Department) to "Department)Perform LookupJob Title to DepartmentDecide if Employee isActive or InactiveSort NamesRemove "-" from Employee IDSeparateactivefrominactiveConvert String toDate and timecalculate time of employmentfrom start till todaycalculate time of employmentfrom start to endconcatenatetable together- Remove column "id"- First_name to FirstName-Last_name to LastName-LastName befor FirstNameConnect toCustomerData.sqliteSelectTable"Countries"Join on EmployeeID with countriesvalidate dataLoad templateLoad data to DBCSV Reader Excel Reader Cell Replacer Rule Engine Sorter String Manipulation Row Splitter String to Date&Time Date&TimeDifference Date&TimeDifference Concatenate Table Manipulator SQLite Connector DB Table Selector DB Reader Joiner Table Validator(Reference) CSV Reader DB 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: Ana Vedoveli
Created at: 2021-10-21
On NodePit since: 2021-11-04
Last update: 2024-11-17
Created with KNIME version: v4.4.1

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

Try NodePit Runner!