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)
Current Stock Status to GCP and PostgreSQL
ALT Assistant GPT File Creation
ALT sales wf stock Items
GCP Connection
Postgres Connection
Read Data from alt02_item_store_action
DB Query Reader
Group Items and store
GroupBy
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
Write to temp
DB Writer (deprecated)
DB Loader
Insert to prod; clean up
DB SQL Executor
Insert to prod Clean up
DB SQL Executor
Format dates
String to Date&Time (deprecated)
Create File/Folder Variables
Insert to prod Clean up
DB SQL Executor
Insert to prod Clean up
DB SQL Executor
convert alt id to int
String Manipulation
Rule-based Row Filter
Rename
Column Rename (deprecated)
Rename
Column Rename (deprecated)
Filter for DB addition
Column Filter
Merge
Concatenate
Column Filter
Add "stock" column
Constant Value Column (deprecated)
Merge
Concatenate
Table Row to Variable
Add "non-stock" column
Constant Value Column (deprecated)
Verify Identity to System
Microsoft Authenticator
Add "stock" column
Constant Value Column (deprecated)
Joiner
Fix Reset ID to RESET######
Column Expressions (legacy)
String Manipulation (Multi Column)
Remove ALT ID's already parsed
Joiner
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
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
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
Stock requests
Column Filter
Insert to prod; clean up
DB SQL Executor
Only Approved Requests
Rule-based Row Filter
item_list.csv
CSV Writer
Column Rename (deprecated)
Validate Access to GCP
Google Authenticator
Remove dupes
Duplicate Row Filter
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
DB Table Creator
DB Loader
Stock
Excel Reader
Load Stage Table
DB Writer (deprecated)
Remove whitespace Remove characters from comments (see node for more details)
Column Expressions (legacy)
Store Match = True
Row Filter (deprecated)
Row Filter
Load alt_analysis_sales
DB SQL Executor
District-to-store
Joiner
Postgres Production Connection
Unique item list
GroupBy
Table Row to Variable
Keep only needed columns
Column Filter
Number format
Column Expressions (legacy)
Write to temp
DB Writer (deprecated)
Connect to SharePoint
SharePoint Online Connector
Non-stock requests
Column Filter
Combine
Joiner
DB Names
Column Rename (deprecated)
Load alt_analysis_sales
DB SQL Executor
Rename to DB names
Column Rename (deprecated)
Filter to high-level request info
Column Filter
Sorter
Load ALT approval Info to temp
DB Writer (deprecated)
Join
Joiner
Format columns
Column Expressions (legacy)
Store List
DB Query Reader
Load ALT Request Info to temp
DB Writer (deprecated)
Remove Duplicates
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
Table Row to Variable Loop Start
Keep Needed Columns
Column Filter
Loop End (deprecated)
Keep Needed Columns
Column Filter
COO
Excel Reader
Item Level Sales data
DB Query Reader
Keep Needed Columns
Column Filter
Rename
Column Rename (deprecated)
Merge
Concatenate
Rename
Column Rename (deprecated)
Rename
Column Rename (deprecated)
Google BigQuery Connector

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-10-01
Last update: 2026-10-01
Created with KNIME version: v5.8.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!