Icon

FM_​ALT (GCP)

ALT Request Details
Pull Approval File w/ Comments
Parse store list (if no store entered, determine from district, if possible)
Manual Review Needed
Store listed in ALT
SharePoint Connector
Write to GCP
Parse item list
Determine if Item/Store already stored for ALT ID - TRUE - No action needed (skip) - FALSE - Determine item and store list and load data
ALT Location Override (ONLY if algorithm does not determine correctly)
GCP Connector
Current Stock Status to GCP and PostgreSQL
Sales Data to GCP
ALT Assistant GPT File Creation
DB Loader
GCP - Pull ALT item/store combos
DB Query Reader
Insert to prod; clean up
DB SQL Executor
temp_alt02_item_store_action_status
DB Table Creator
temp_alt03_approvals
DB Table Creator
PostgreSQL (prod - read/write)
PostgreSQL Connector
Write to temp
DB Writer
DB Loader
Insert to prod; clean up
DB SQL Executor
Insert to prod Clean up
DB SQL Executor
PostgreSQL (prod - read/write)
PostgreSQL Connector
Create File/Folder Variables
Insert to prod Clean up
DB SQL Executor
Insert to prod Clean up
DB SQL Executor
Rename
Column Rename (deprecated)
Rename
Column Rename (deprecated)
Filter for DB addition
Column Filter
Merge
Concatenate
Add "stock" column
Constant Value Column (deprecated)
Merge
Concatenate
Table Row to Variable
Add "non-stock" column
Constant Value Column (deprecated)
DB Loader
Sorter
Insert to prod; clean up
DB SQL Executor
Add "stock" column
Constant Value Column (deprecated)
Joiner
Filter out 0 and wrong dates
Rule-based Row Filter
Fix Reset ID to RESET######
Column Expressions (legacy)
String Manipulation (Multi Column)
Remove ALT ID's already parsed
Joiner
temp_alt06_sales
DB Table Creator
Add "non-stock" column
Constant Value Column (deprecated)
ALT LOCATION MANUAL OVERRIDE
Table Creator
District to number
String to Number
Filter out Reset ID column
Column Filter
Ungroup
Row Filter (deprecated)
Remove Array Column
Column Filter
Filter to rows w/ Reset
Column Filter
Split out delimited districts
Cell Splitter
RFM Sales ID
DB Query Reader
Add RFM Sales ID
Joiner
Sign in with your GCP Account
Google Authenticator (Deprecated)
temp_alt01_request_detail
DB Table Creator
Pull ALT ID's already stored
DB Query Reader
Insert to prod; clean up
DB SQL Executor
DB Loader
Submitted to date type
String to Date&Time (deprecated)
Standardize ALT request type
Rule Engine
Trim whitespace & lowercase
String Manipulation (Multi Column)
Split out delimited items
Cell Splitter
Unique list
GroupBy
Stock requests
Column Filter
GCP > Sales Data by Week
DB Query Reader
Insert to prod; clean up
DB SQL Executor
Pull approved item/store/ for approved stock requests Measure Date = last date sales was pulled or reset completion/end date
DB Query Reader
Only Approved Requests
Rule-based Row Filter
Bigquery Connector
Google BigQuery Connector
Loop End
Loop End
item_list.csv
CSV Writer
Column Rename (deprecated)
Loop Start
Table Row to Variable Loop Start
Column Filter
Column Resorter
Join to ALT ID, Item, Store
Joiner
Remove dupes
Duplicate Row Filter
PostgreSQL (prod - read/write)
PostgreSQL Connector
PostgreSQL (prod - read/write)
PostgreSQL Connector
Item List
DB Query Reader
Rename
Column Rename (deprecated)
Ungroup
GCP - Store Details
DB Query Reader
Filter out non-numbers and zeroes
Row Filter (deprecated)
Item to number
String to Number
Tariff Disruption List
Excel Reader
Check if store is blank
Rule-based Row Splitter
Stock
Excel Reader
Microsoft Authenticator
Remove whitespace Remove characters from comments (see node for more details)
Column Expressions (legacy)
Store Match = True
Row Filter (deprecated)
District-to-store
Joiner
Unique item list
GroupBy
Table Row to Variable
Keep only needed columns
Column Filter
Number format
Column Expressions (legacy)
Write to temp
DB Writer
Connect to SharePoint
SharePoint Online Connector
Non-stock requests
Column Filter
Combine
Joiner
DB Names
Column Rename (deprecated)
Rename to DB names
Column Rename (deprecated)
Filter to high-level request info
Column Filter
Sorter
Load ALT approval Info to temp
DB Writer
Join
Joiner
Format columns
Column Expressions (legacy)
Store List
DB Query Reader
Load ALT Request Info to temp
DB Writer
Remove dupes
Duplicate Row Filter
tracking_measurement.csv
CSV Writer
Trim whitespace
String Manipulation (Multi Column)
Item only
Column Filter
Filter blanks
Rule-based Row Filter
DB Loader
store_list.csv
CSV Writer
Sorter
Insert to prod; clean up
DB SQL Executor
Column Rename (deprecated)
Non-stock if missing
Rule Engine
Tariff = true
Constant Value Column (deprecated)
Column Rename (deprecated)
Column Rename (deprecated)
Remove weird characters
String Manipulation (Multi Column)
Item List + Tariff Indicator
Joiner
Split out delimited stores
Cell Splitter
Store to number
String to Number
Replace store list (if needed)
Column Expressions (legacy)
Revelant columns
Column Filter
Remove Array Column
Column Filter
temp_alt02_item_store_action
DB Table Creator
Tracking & Measurement
DB Query Reader
Combine
Joiner
Ungroup
GCP - Current Stock IDC
DB Query Reader
Assortment edits only
Row Filter (deprecated)
Format columns
Column Expressions (legacy)
Folder > Latest File
FY 2025 and later only
Date&Time-based Row Filter
Only needed columns
Column Filter
Filter out blank comments
Row Filter (deprecated)
Select CSV file
List Files/Folders
Connect to ZIP file
ZIP Archive Connector
Read CSV from ZIP
File Reader (Complex Format)
No store or district match
Joiner
Manual review
GroupBy
Combine
Concatenate
Non-Stock
Excel Reader
District Match = True
Row Filter (deprecated)
Determine store or district match (see node for more details)
Column Expressions (legacy)
Add "stock" column
Constant Value Column (deprecated)
Column Resorter
Filter for DB addition
Column Filter
Requests w/o store matches
Joiner
Keep Needed Columns
Column Filter
Keep Needed Columns
Column Filter
COO
Excel Reader
Keep Needed Columns
Column Filter
Rename
Column Rename (deprecated)
Merge
Concatenate
Rename
Column Rename (deprecated)
Rename
Column Rename (deprecated)

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: 2025-12-02
On NodePit since: 2026-06-19
Last update: 2026-06-20
Created with KNIME version: v5.8.2

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

Try NodePit Runner!