Icon

Data Wrangling _​ Conditional Loop based on Sepcific Column Value (two sources)

https://forum.knime.com/t/conditional-loop-based-on-specific-column-value/64155

old databefore 2020new data after 2020full outer join years wideshape yearslong formatvalidate ID max YEARstart loop ID / max YEAR to variablefilter case IFID YEAR == max YEARfilter case IFID YEAR == max YEARCase TRUEcolect max YEAR validated dataTable Creator Table Creator Joiner Unpivoting GroupBy Table Row ToVariable Loop Start Rule-basedRow Filter Rule-basedRow Filter End IF Loop End old databefore 2020new data after 2020full outer join years wideshape yearslong formatvalidate ID max YEARstart loop ID / max YEAR to variablefilter case IFID YEAR == max YEARfilter case IFID YEAR == max YEARCase TRUEcolect max YEAR validated dataTable Creator Table Creator Joiner Unpivoting GroupBy Table Row ToVariable Loop Start Rule-basedRow Filter Rule-basedRow Filter End IF Loop End

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: RE90273
Created at: 2023-03-24
On NodePit since: 2023-03-25
Last update: 2024-05-01
Created with KNIME version: v4.7.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!