Icon

Check for sequential INV numbers_​v2

Loop endPresentation of the results(read flow variables)Conversionof all rows to “Year”inRow Variables (until all rows have been run through)Transformed"Year"from data setin flow variableDefinition ofport conditions,which activate the affected portExplanation of conditions:If the condition is met, the corresponding ports should be opened$${SYear}$$ = $${IYear (-5)}$$ =>"0"$${SYear}$$ = $${IYear (-4)}$$ =>"1"$${SYear}$$ = $${IYear (-3)}$$ =>"2"$${SYear}$$ = $${IYear (-2)}$$ =>"3"$${SYear}$$ = $${IPrevious Year}$$ =>"4"$${SYear}$$ = $${ICurrent Year}$$ =>"5"Activation criterion (flow variable): PortExplanation:- Port opening for affected rowsCollectsResultsPort opensdepending on the yearCreates tablewithexamples to INV#(one vendor)Transformation of"key1" in integerNew column: "key2"Removes characters(currently: 8 digits for "key1" for INV#)Transformsstring to date&timeFilter onrelevant columnsTransformation of"key2" and "Year" in StringTransformsYearsintoFlow variableExtracts yearCalculatesrelevantDatesStart for"Year"Replaces missing valuesfor "key2"by "missing"RenamesColumn "key2"in "Vendor INV#"Collects OutputCalculates"SUM INV"Node 541CalculatesCount forRangeGroup: "Year"CalculatesCount forRangeCalculates"Sequential rate in %"Group: "Year"CalculatesSum forsequential andnon-sequentialRenames Count*(Range)to"Non-Sequential"Renames Count*(Range)to"Sequential"Calculate lowest“Count”Node 549Transformation of"key1" in integerConversion data typefor "Max Count" in INTNode 552Conversion data typefor "Min Count" in INTTransformation"Max Count"in flow variableCalculate highest“Count”Upper port: No empty tableLower port: When the table is emptyFilter onrelevant ColumnsNode 559Createsempty tableCreates numeric rangebased on given parametersAcceptance of the flow variablefor"Last Value"Loop endand data collectingInclude"Year"as VariableNode 567Node 568Filter onrelevant ColumnsNode 571Node 572Include"Year"as VariableFilter onrelevant ColumnsCalculates"Non-Sequential Rate in %"Appends:Sequential invoice numbersValue: "Existent"Appends:Sequential invoice numbersValue: "Not existent"Re-sortingCreates rankingbased on sequential quotaConditions:$Sequential Quota in %$ = 100 => 1$Sequential Quota in %$ >= 80 AND $Sequential Quota in %$ < 100 => 2$Sequential Quota in %$ < 80 => 3Set heatmap colorsDisplay and heatmap(Ranking based on ranking)Filter onrelevant columnsRe-sortingDescending sortingby rankingCreates tablewithexamples to INV#(multiple vendors)Extracts yearTransformsstring to date&timeRemoves characters(currently: 8 digits for "key1" for INV#)vendoryearkey Variable Loop End Table Row toVariable Loop Start Table Rowto Variable Rule EngineVariable CASE Switch Start CASE Switch End Row Filter Metanode Table Creator String Manipulation String Manipulation String to Date&Time Column Filter Number to String Table Rowto Variable Extract Date&TimeFields Relevant Dates Group Loop Start ConstantValue Column Column Renamer End IF Math Formula Concatenate GroupBy GroupBy Math Formula GroupBy Column Renamer Column Renamer Math Formula Joiner String Manipulation String Manipulation Joiner String Manipulation Table Rowto Variable Math Formula Empty Table Switch Column Filter Concatenate Table Creator Create NumericRange Loop End Table Rowto Variable Cell Updater Column Appender Column Filter Column Appender Cell Updater Table Rowto Variable Column Filter Missing Value Math Formula ConstantValue Column ConstantValue Column Column Resorter Rule Engine Color Manager Table View(JavaScript) Column Filter Column Resorter Sorter Table Creator Rank Extract Date&TimeFields String to Date&Time String Manipulation Sorter Loop endPresentation of the results(read flow variables)Conversionof all rows to “Year”inRow Variables (until all rows have been run through)Transformed"Year"from data setin flow variableDefinition ofport conditions,which activate the affected portExplanation of conditions:If the condition is met, the corresponding ports should be opened$${SYear}$$ = $${IYear (-5)}$$ =>"0"$${SYear}$$ = $${IYear (-4)}$$ =>"1"$${SYear}$$ = $${IYear (-3)}$$ =>"2"$${SYear}$$ = $${IYear (-2)}$$ =>"3"$${SYear}$$ = $${IPrevious Year}$$ =>"4"$${SYear}$$ = $${ICurrent Year}$$ =>"5"Activation criterion (flow variable): PortExplanation:- Port opening for affected rowsCollectsResultsPort opensdepending on the yearCreates tablewithexamples to INV#(one vendor)Transformation of"key1" in integerNew column: "key2"Removes characters(currently: 8 digits for "key1" for INV#)Transformsstring to date&timeFilter onrelevant columnsTransformation of"key2" and "Year" in StringTransformsYearsintoFlow variableExtracts yearCalculatesrelevantDatesStart for"Year"Replaces missing valuesfor "key2"by "missing"RenamesColumn "key2"in "Vendor INV#"Collects OutputCalculates"SUM INV"Node 541CalculatesCount forRangeGroup: "Year"CalculatesCount forRangeCalculates"Sequential rate in %"Group: "Year"CalculatesSum forsequential andnon-sequentialRenames Count*(Range)to"Non-Sequential"Renames Count*(Range)to"Sequential"Calculate lowest“Count”Node 549Transformation of"key1" in integerConversion data typefor "Max Count" in INTNode 552Conversion data typefor "Min Count" in INTTransformation"Max Count"in flow variableCalculate highest“Count”Upper port: No empty tableLower port: When the table is emptyFilter onrelevant ColumnsNode 559Createsempty tableCreates numeric rangebased on given parametersAcceptance of the flow variablefor"Last Value"Loop endand data collectingInclude"Year"as VariableNode 567Node 568Filter onrelevant ColumnsNode 571Node 572Include"Year"as VariableFilter onrelevant ColumnsCalculates"Non-Sequential Rate in %"Appends:Sequential invoice numbersValue: "Existent"Appends:Sequential invoice numbersValue: "Not existent"Re-sortingCreates rankingbased on sequential quotaConditions:$Sequential Quota in %$ = 100 => 1$Sequential Quota in %$ >= 80 AND $Sequential Quota in %$ < 100 => 2$Sequential Quota in %$ < 80 => 3Set heatmap colorsDisplay and heatmap(Ranking based on ranking)Filter onrelevant columnsRe-sortingDescending sortingby rankingCreates tablewithexamples to INV#(multiple vendors)Extracts yearTransformsstring to date&timeRemoves characters(currently: 8 digits for "key1" for INV#)vendoryearkeyVariable Loop End Table Row toVariable Loop Start Table Rowto Variable Rule EngineVariable CASE Switch Start CASE Switch End Row Filter Metanode Table Creator String Manipulation String Manipulation String to Date&Time Column Filter Number to String Table Rowto Variable Extract Date&TimeFields Relevant Dates Group Loop Start ConstantValue Column Column Renamer End IF Math Formula Concatenate GroupBy GroupBy Math Formula GroupBy Column Renamer Column Renamer Math Formula Joiner String Manipulation String Manipulation Joiner String Manipulation Table Rowto Variable Math Formula Empty Table Switch Column Filter Concatenate Table Creator Create NumericRange Loop End Table Rowto Variable Cell Updater Column Appender Column Filter Column Appender Cell Updater Table Rowto Variable Column Filter Missing Value Math Formula ConstantValue Column ConstantValue Column Column Resorter Rule Engine Color Manager Table View(JavaScript) Column Filter Column Resorter Sorter Table Creator Rank Extract Date&TimeFields String to Date&Time String Manipulation Sorter

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: causevia
Created at: 2024-03-12
On NodePit since: 2024-03-13
Last update: 2024-11-24
Created with KNIME version: v5.2.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!