Icon

MST_​Capacity_​2026

DCT Reset
Workfront Reset
Plant Service Plan
Scheduling Data
Plant Service Plan by Jobcode
Combine Data
Calculate Service Plan
Remove Service Plan for Unopened Stores
Update hrs03hours_model (Postgres)
Update hrs04plant_service_plan (Postgres)
Hours Model (Capacity Plan) Workflow Pull scheduling data details for ingestion into the Postgres DatabaseUpdates MST Task Expectations by Store and Week*Workflow runs daily on weekdays at 3 PM EST. **You Must Open and Log in to Nodes in the Red Boxes**
Authorized Hours Data
Postgres Connection
GCP Connection
Rolls it up to Fiscal wk level
GroupBy
Removed Days and Add fiscal wk end dt
Joiner
re-names to match naming conventions
Column Rename (deprecated)
Removed Days and Add fiscal wk end dt
Joiner
Rolls it up to Fiscal wk level
GroupBy
Filters to Next Week + 2 Weeks Out
Date&Time-based Row Filter
Use Path to Pull Holy Grail Data
Excel Reader
Writes to Temp Table
DB Writer
Renames Columns
Column Rename (deprecated)
Removes Scheduled Columns
Column Filter
Removes Overall Plan
Column Filter
Brings the hours in by Jobcode as columns
DB Query Reader
Renames Pivoted Columns
Column Rename (deprecated)
Pivots Jobcodes so that they are in one column
Unpivot
Rounds Reset and Service Plan to one decimal place
Math Formula (Multi Column)
Converts to Date
String to Date&Time (deprecated)
Pull Workfront Reset List
DB Query Reader
Give Current Date
Create Date&Time Range (deprecated)
Returns 2 Weeks Out
Date&Time Shift (deprecated)
PostgreSQL (prod - read/write)
PostgreSQL Connector
Filters to workfront range
Rule-based Row Filter
Resorts Columns
Column Resorter
Adds column to mark Workfront Start
Column Appender
Filters out any NULL Values
Row Filter (deprecated)
Removes RowID's
Column Filter
Adds in Workfront (Over 2 weeks out)
Joiner
Updates hrs04plant_service_plan
DB SQL Executor
Drops Temp Table
DB SQL Executor
Removes unecssary WF Column
Column Filter
Combines WF and DCT Plan into one column
Column Expressions (legacy)
Writes to Temp Table
DB Writer
Combines Store Service Start Date
Joiner
Removes Service Expectation for Stores before their Service Start Date
Column Expressions (legacy)
Pulls Reset Data
DB Query Reader
Pulls Filter Start Date and End Date
DB Query Reader
Filters out uneccesary columns
Column Filter
Table Row to Variable
Assign Start & End Date to Variables
Table Row to Variable
Filters Out any Stores/Week Combos with 0 Auth Hours
Row Filter (deprecated)
Removes Service Start Date
Column Filter
Re-orders Columns
Column Resorter
Calculates Spread Date
Column Expressions (legacy)
Joins with Plant Service Plan
Joiner
Brings Dates to a Column
Unpivot
Converts to Day Name
Date&Time Part Extractor
Pulls in Authorized Hours
DB Query Reader
Connect to SharePoint Folder - Node 788
SharePoint Online Connector
Starts Loop
Group Loop Start
Pulls Days Between
Create Date&Time Range (deprecated)
Captures All Loop Data
Loop End
Converts to Day Name
Date&Time Part Extractor
Removes Saturday & Sunday
Rule-based Row Filter
Adds PTO, Schedules, and LN Plan to Reset Hours by Store by Week
Joiner
Captures All Loop Data
Loop End
Pulls Days Between
Create Date&Time Range (deprecated)
Removes Saturday & Sunday
Rule-based Row Filter
Pulls all Data Together with Days Between
Cross Joiner
Pulls all Data Together with Days Between
Cross Joiner
Starts Loop
Group Loop Start
Table Row to Variable
Reset Hrs. by Store and Day
Joiner
Calculated Avg. Hrs per Day
Column Expressions (legacy)
Writes to Temp Table
DB Writer
Updates hrs03hours_model
DB SQL Executor
Open Node and Sign in with your GCP Account
Google Authenticator (Deprecated)
Hours and Service Calclations
Hours Calc
Calculated Avg. Hrs per Day
Column Expressions (legacy)
Calculates Plan Hrs and Days
GroupBy
Pulls Blue, Green, PTO Scheduled
DB Query Reader
You Must Open this Node and Click the LOGIN Button.
Microsoft Authenticator
Calculates Plan Hrs and Days
GroupBy
Column Resorter
Pulls Calendar Information
DB Query Reader
Renames Columns
Column Rename (deprecated)
Bigquery Connector
Google BigQuery Connector
Reset Hrs. by Store and Day
Joiner
Includes everything upt to 12 weeks out
Date&Time-based Row Filter
Combines LN Plan and Schedule
Joiner
Use Path to Pull HolyGrail Data
Excel Reader

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: tlawing
Created at: 2023-12-08
On NodePit since: 2026-06-23
Last update: 2026-06-27
Created with KNIME version: v5.8.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!