Icon

New_​RCO_​Scheduled_​Workflow

Iteration over each Line and specified TimeframeTop Flow requests Uptime/Downtime DataBottom Flow requests Production Data Reads in SKU Data such as SKU Volume this is used for Identification of Product Category (DF/DC) Flags Data that is to be excluded (PR:Out) andRemoves entries DC/DF Identification Output toOralInsights Serverand Storage of Datain File Computes Date-Based Columns such as Production Day (6Am - 6Am), Financial Year, Calendar Week etc. Merges Reason Trees Global vs. Regular Proficy Entry as some Entries are not in Global Column in ProficyFilters Columns that were used for Computation purposes Identifies Stops that occurr after Changeover and marks those entries.Computes time in between CO and first StopLinks Stops to Changeover Workaround for C/O targetdurations Reads currently File-Based Data Storage (2019-yesterday) Erases previous 7 days of data from FileConcatenates new Data to stored Data Takes execution date and creates Table previous 7 days. Joins all Lines from DFPData is requested from Proficy in the next step Node 1Node 2Node 4Node 5Node 6Node 45Node 47All PathsAPI link frameworkwith variables for line& start + end dateComputes MSU from Stat UnitsNode 61Node 66Node 68Node 70Loops Line by LineNode 79Node 83Node 693Node 714Node 737Node 739Node 748Node 751Creates Table with Execution Date1 Row for each Line(adjust manually)Shifts each Date7 days backBrings Date into correct formatfor rest requestChanges date typeto stringRenames ColumnsCreates Row for each Line IDAppends both tablesungroups json liststo rowsselects required columnssends API request to Proficyplaces line id + datesinto link placeholder positionsNode 783Node 785extract yearshift back 3 monthsNode 798add one yearcreate financial year columnNode 804Node 806Node 808Node 809Node 810Node 816Node 817Node 820Node 822Node 833Node 835Node 837Node 838Node 841Node 842Node 844Node 845Node 846Node 847Node 848Node 849extract yearshift back 3 monthsNode 852Node 853Node 854Node 856create financial year columnNode 858Node 859Node 860Node 861Node 862Node 864Node 865add one yearNode 867Node 871Node 874Node 878Node 879Node 882Node 883Node 886Node 887Node 888Node 889Node 890Node 891Node 892Node 893Node 894Node 895Node 896Node 899Node 900Node 903Node 904Node 905Node 906Node 908Node 912Node 914Node 915Node 916Node 918Node 919Node 920Node 921 Excel Reader (XLS)(deprecated) Cell Splitter Column Merger String Replacer Column Filter Table Column toVariable (deprecated) String Manipulation GET Request ConstantValue Column Math Formula ConstantValue Column JSON Path Ungroup Loop End (2 ports) Group Loop Start Column Filter String to Date&Time String Manipulation Column Filter Column Resorter Column Rename String Manipulation Rule Engine Create Date&TimeRange Date&Time Shift Modify Time Date&Time to String Column Rename Table Creator Column Appender(deprecated) Ungroup JSON Path GET Request String Manipulation GroupBy Concatenate Extract Date&TimeFields Date&Time Shift Extract Date&TimeFields Math Formula String Manipulation Column Expressions Rule-basedRow Filter Joiner Number To String String Replacer Date&TimeDifference Rule-basedRow Filter Modify Time Date&Time Shift DuplicateRow Filter Column Filter Rule-basedRow Filter Lag Column Column Combiner Lag Column Group Loop Start Loop End String to Date&Time Column Filter Modify Time Date&Time Shift Extract Date&TimeFields Date&Time Shift Extract Date&TimeFields Column Expressions Column Merger Column Resorter String Manipulation Column Filter String Manipulation String Manipulation GroupBy Math Formula Column Filter Column Merger Column Rename Math Formula Rule-basedRow Filter Sorter Joiner Lag Column Column Rename Joiner Excel Reader (XLS)(deprecated) GroupBy Concatenate Rule Engine Lag Column Rule Engine Sorter Lag Column Column Filter Sorter String to Date&Time String to Date&Time String to Date&Time String to Date&Time File Reader Create Date&TimeRange Date&Time Shift Rule-basedRow Filter Rule-basedRow Filter Send to TableauServer Send to TableauServer Column AutoType Cast String Manipulation CSV Writer CSV Writer CSV Reader Number To String Iteration over each Line and specified TimeframeTop Flow requests Uptime/Downtime DataBottom Flow requests Production Data Reads in SKU Data such as SKU Volume this is used for Identification of Product Category (DF/DC) Flags Data that is to be excluded (PR:Out) andRemoves entries DC/DF Identification Output toOralInsights Serverand Storage of Datain File Computes Date-Based Columns such as Production Day (6Am - 6Am), Financial Year, Calendar Week etc. Merges Reason Trees Global vs. Regular Proficy Entry as some Entries are not in Global Column in ProficyFilters Columns that were used for Computation purposes Identifies Stops that occurr after Changeover and marks those entries.Computes time in between CO and first StopLinks Stops to Changeover Workaround for C/O targetdurations Reads currently File-Based Data Storage (2019-yesterday) Erases previous 7 days of data from FileConcatenates new Data to stored Data Takes execution date and creates Table previous 7 days. Joins all Lines from DFPData is requested from Proficy in the next step Node 1Node 2Node 4Node 5Node 6Node 45Node 47All PathsAPI link frameworkwith variables for line& start + end dateComputes MSU from Stat UnitsNode 61Node 66Node 68Node 70Loops Line by LineNode 79Node 83Node 693Node 714Node 737Node 739Node 748Node 751Creates Table with Execution Date1 Row for each Line(adjust manually)Shifts each Date7 days backBrings Date into correct formatfor rest requestChanges date typeto stringRenames ColumnsCreates Row for each Line IDAppends both tablesungroups json liststo rowsselects required columnssends API request to Proficyplaces line id + datesinto link placeholder positionsNode 783Node 785extract yearshift back 3 monthsNode 798add one yearcreate financial year columnNode 804Node 806Node 808Node 809Node 810Node 816Node 817Node 820Node 822Node 833Node 835Node 837Node 838Node 841Node 842Node 844Node 845Node 846Node 847Node 848Node 849extract yearshift back 3 monthsNode 852Node 853Node 854Node 856create financial year columnNode 858Node 859Node 860Node 861Node 862Node 864Node 865add one yearNode 867Node 871Node 874Node 878Node 879Node 882Node 883Node 886Node 887Node 888Node 889Node 890Node 891Node 892Node 893Node 894Node 895Node 896Node 899Node 900Node 903Node 904Node 905Node 906Node 908Node 912Node 914Node 915Node 916Node 918Node 919Node 920Node 921 Excel Reader (XLS)(deprecated) Cell Splitter Column Merger String Replacer Column Filter Table Column toVariable (deprecated) String Manipulation GET Request ConstantValue Column Math Formula ConstantValue Column JSON Path Ungroup Loop End (2 ports) Group Loop Start Column Filter String to Date&Time String Manipulation Column Filter Column Resorter Column Rename String Manipulation Rule Engine Create Date&TimeRange Date&Time Shift Modify Time Date&Time to String Column Rename Table Creator Column Appender(deprecated) Ungroup JSON Path GET Request String Manipulation GroupBy Concatenate Extract Date&TimeFields Date&Time Shift Extract Date&TimeFields Math Formula String Manipulation Column Expressions Rule-basedRow Filter Joiner Number To String String Replacer Date&TimeDifference Rule-basedRow Filter Modify Time Date&Time Shift DuplicateRow Filter Column Filter Rule-basedRow Filter Lag Column Column Combiner Lag Column Group Loop Start Loop End String to Date&Time Column Filter Modify Time Date&Time Shift Extract Date&TimeFields Date&Time Shift Extract Date&TimeFields Column Expressions Column Merger Column Resorter String Manipulation Column Filter String Manipulation String Manipulation GroupBy Math Formula Column Filter Column Merger Column Rename Math Formula Rule-basedRow Filter Sorter Joiner Lag Column Column Rename Joiner Excel Reader (XLS)(deprecated) GroupBy Concatenate Rule Engine Lag Column Rule Engine Sorter Lag Column Column Filter Sorter String to Date&Time String to Date&Time String to Date&Time String to Date&Time File Reader Create Date&TimeRange Date&Time Shift Rule-basedRow Filter Rule-basedRow Filter Send to TableauServer Send to TableauServer Column AutoType Cast String Manipulation CSV Writer CSV Writer CSV Reader Number To String

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: neidhoefer.j
Created at: 2021-06-02
On NodePit since: 2026-02-04
Last update: 2026-02-07
Created with KNIME version: v5.2.5

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

Try NodePit Runner!