Icon

Group data and transform from rows to columns

sample dataSee what previous"type" was sowe can then seewhen it changeshas type changed since previous type1 if it has and 0 if it hasn'tCumulativelySum all the "type changed" values up to each row.This is a technique that canbe used, in conjunction with the Rule Engine producing 1s and 0s, to allocate a "group number"to each "group" of rows that havethe same "type" valueGet max and min datesfor each group numberjoin ongrouping numberand filterunwanted columnsMake column name clearerfor the "group number"columnrename max and minas end_date and start_dateKeep just firstrow for each grouptidy upTable Creator Lag Column Rule Engine Moving Aggregation GroupBy Joiner Column Rename Column Rename DuplicateRow Filter Column Filter sample dataSee what previous"type" was sowe can then seewhen it changeshas type changed since previous type1 if it has and 0 if it hasn'tCumulativelySum all the "type changed" values up to each row.This is a technique that canbe used, in conjunction with the Rule Engine producing 1s and 0s, to allocate a "group number"to each "group" of rows that havethe same "type" valueGet max and min datesfor each group numberjoin ongrouping numberand filterunwanted columnsMake column name clearerfor the "group number"columnrename max and minas end_date and start_dateKeep just firstrow for each grouptidy upTable Creator Lag Column Rule Engine Moving Aggregation GroupBy Joiner Column Rename Column Rename DuplicateRow Filter Column 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: BATEB031
Created at: 2022-09-22
On NodePit since: 2022-09-22
Last update: 2024-04-27
Created with KNIME version: v4.6.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!