Icon

04_​Data_​Transformation_​2

1. Convert string to Date&Time (use format: M/d/yyyy)2. Use row splitter to separate active and inactive employees3. For active employees, calculate the time of employment in days till today; for inactive employees, calculate the time of employment from the start date to end date4. Concatenate both results together SeparateactivefrominactiveConvert String toDate and timecalculate time of employmentfrom start till todaycalculate time of employmentfrom start to endconcatenatetable together Row Splitter String to Date&Time Date&TimeDifference Date&TimeDifference Concatenate Transformed Data 1. Convert string to Date&Time (use format: M/d/yyyy)2. Use row splitter to separate active and inactive employees3. For active employees, calculate the time of employment in days till today; for inactive employees, calculate the time of employment from the start date to end date4. Concatenate both results together SeparateactivefrominactiveConvert String toDate and timecalculate time of employmentfrom start till todaycalculate time of employmentfrom start to endconcatenatetable together Row Splitter String to Date&Time Date&TimeDifference Date&TimeDifference Concatenate Transformed Data

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-22
On NodePit since: 2021-11-04
Last update: 2024-05-01
Created with KNIME version: v4.4.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!