Icon

PeriodInOut

PeriodInOut
Previous Month This Month Append Columns to each data setmarking rows as (IN and OUT ) and (OUTand IN ) for both current month andprevious month Join rows based on the IN for currentmonth equals OUT for previous monthand vice versa Suggested workflow for assisting withhttps://forum.knime.com/t/count-inwards-and-outwards-from-one-period-to-another-period/319252 April 2021 @takbb Brian Bates Feb 2021Jan2021Sort DateAscendingSort Date AscendingNode 5IN OUT OUT INNode 7Node 8 Table Creator Table Creator Sorter Sorter Column Appender Table Creator Column Appender Joiner Previous Month This Month Append Columns to each data setmarking rows as (IN and OUT ) and (OUTand IN ) for both current month andprevious month Join rows based on the IN for currentmonth equals OUT for previous monthand vice versa Suggested workflow for assisting withhttps://forum.knime.com/t/count-inwards-and-outwards-from-one-period-to-another-period/319252 April 2021 @takbb Brian Bates Feb 2021Jan2021Sort DateAscendingSort Date AscendingNode 5IN OUT OUT INNode 7Node 8 Table Creator Table Creator Sorter Sorter Column Appender Table Creator Column Appender Joiner

Nodes

Extensions

Links