Icon

Workflow- ‘Loop and rule engine’ but without Loop, or Rule Engine!

Compare the results of the original flow with this new flow Original flow to compare against This section for testing purposes Data from original workflow, in data area of workflow as csv file Initial data prep (data into "row" format instead of tabulated) Build thefoundation forthe "totals"columns Put row data back intotabulated form Bring summarised information back to original table Sort the Totals columns into calendar orderNode 18Node 19Node 20I've adjusted this to returnInt to make comparison easierNode 68Copy of data in csv format.Put data in a formwe can processSort into ID and "period name" orderGet standard Periodname for eachGet firstvalue (in row order) for each period for each id(ignores missingvalues)Create a "title" that willbecome a column name.keep in the numeric periodfor the moment as when we pivot it willsort columns in name orderBuild a date so we canextract month nameMake periodDateinto a Date columnso we can get name of monthGet month nametidy upPut back intotabular formatone row per IDBring coalesced, summariseddata backto the main tableRemove the numeric portion of columnname that was used forsorting purposesAllow us to keep original sort orderSort by the counter we created earlierto retain originalrow orderTidy up.This is theend point forthe actual flowCalculate Total for each IDAny differences?Comparable RowIDComparable RowIDSort by IDSort by IDFix missing periodsto zeroTop flow disabled=success!If it gets here,something went wrong Selected ColumnResorter Rule Engine Rule Engine Rule Engine Math Formula Rule Engine CSV Reader Unpivoting Sorter String Manipulation GroupBy String Manipulation String Manipulation String to Date&Time Date&Time to String Column Filter Pivoting Joiner Column Rename(Regex) Counter Generation Sorter Column Filter Column Aggregator Table DifferenceFinder RowID RowID Sorter Sorter Missing Value Empty Table Switch Fail in execution Compare the results of the original flow with this new flow Original flow to compare against This section for testing purposes Data from original workflow, in data area of workflow as csv file Initial data prep (data into "row" format instead of tabulated) Build thefoundation forthe "totals"columns Put row data back intotabulated form Bring summarised information back to original table Sort the Totals columns into calendar orderNode 18Node 19Node 20I've adjusted this to returnInt to make comparison easierNode 68Copy of data in csv format.Put data in a formwe can processSort into ID and "period name" orderGet standard Periodname for eachGet firstvalue (in row order) for each period for each id(ignores missingvalues)Create a "title" that willbecome a column name.keep in the numeric periodfor the moment as when we pivot it willsort columns in name orderBuild a date so we canextract month nameMake periodDateinto a Date columnso we can get name of monthGet month nametidy upPut back intotabular formatone row per IDBring coalesced, summariseddata backto the main tableRemove the numeric portion of columnname that was used forsorting purposesAllow us to keep original sort orderSort by the counter we created earlierto retain originalrow orderTidy up.This is theend point forthe actual flowCalculate Total for each IDAny differences?Comparable RowIDComparable RowIDSort by IDSort by IDFix missing periodsto zeroTop flow disabled=success!If it gets here,something went wrongSelected ColumnResorter Rule Engine Rule Engine Rule Engine Math Formula Rule Engine CSV Reader Unpivoting Sorter String Manipulation GroupBy String Manipulation String Manipulation String to Date&Time Date&Time to String Column Filter Pivoting Joiner Column Rename(Regex) Counter Generation Sorter Column Filter Column Aggregator Table DifferenceFinder RowID RowID Sorter Sorter Missing Value Empty Table Switch Fail in execution

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: lorenzofoschi
Created at: 2021-06-09
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.3.3

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

Try NodePit Runner!