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 SharePointConnector Write to GCP Parse item list Determine if Item/Store already storedfor ALT ID- TRUE - No action needed (skip)- FALSE - Determine item and store listand load data ALT Location Override(ONLY if algorithm does not determinecorrectly) GCP Connector Current Stock Statusto GCP and PostgreSQL Sales Data toGCP ALT Assistant GPTFile Creation Keep onlyneeded columnsRenameto DB namesGCP - Current Stock IDCSubmittedto date typeTrim whitespace& lowercaseStandardizeALT requesttypeStockrequestsSplit outdelimited itemsRenameGCP - Store DetailsItem to numberFilter outnon-numbersand zeroesNon-stockrequestsFilter to high-level request info Assortmentedits onlyCombineOnly neededcolumnsFY 2025 and later onlyPostgreSQL(prod - read/write)temp_alt03_approvalsInsert to prod;clean upLoad ALTRequest Info to tempUnique itemlistCombineDB NamesWrite totempStockNon-StockCOOKeep NeededColumnsKeep NeededColumnsKeep NeededColumnsRenameRenameRenameMergeAdd"stock"columnAdd "non-stock"columnAdd "stock"columnFix Reset IDto RESET######Filter torows w/ ResetFilter out Reset IDcolumnJoinLoad ALTapproval Info to tempFilter blanksRemove dupesTrimwhitespaceRemoveweird charactersNon-stockif missingCheck ifstore is blankDistrict-to-storeRemove whitespaceRemove characters from comments(see node for moredetails)Store Match= TrueDistrict Match= TrueDeterminestore or districtmatch(see node for moredetails)Filterfor DB additionRequestsw/o store matchesCombineNo store ordistrict matchManual reviewFilter out blankcommentsConnectto ZIP fileRead CSVfrom ZIPSelect CSV fileAdd "non-stock"columnAdd "stock"columnMergeRenameRenameFilterfor DB additionMergeInsert to prodClean upInsert to prodClean upInsert to prodClean upRemove dupesItem ListPostgreSQL(prod - read/write)PostgreSQL(prod - read/write)item_list.csvOnly ApprovedRequestsBigquery ConnectorSign in with your GCP AccountRFM Sales IDAdd RFM Sales IDInsert to prod;clean uptemp_alt01_request_detailPull ALT ID'salready storedRemove ALT ID'salready parsedALT LOCATIONMANUAL OVERRIDEReplace storelist (if needed)Revelant columnsSplit outdelimited storesStore to numberFormatcolumnsRemoveArray Columntemp_alt02_item_store_actionInsert to prod;clean upGCP - Pull ALTitem/store combostemp_alt02_item_store_action_statusInsert to prod;clean upPostgreSQL(prod - read/write)Write totempInsert to prod;clean upPull approveditem/store/for approved stock requestsMeasure Date =last date sales was pulledor reset completion/end dateUnique listGCP > Sales Databy WeekLoop StartLoop EndJoin toALT ID, Item, StoreInsert to prod;clean uptemp_alt06_salesFilter out 0and wrong datesNode 1323RemoveArray ColumnSplit outdelimited districtsDistrict to numberFormatcolumnsStore ListTracking& Measurementstore_list.csvtracking_measurement.csvItem onlyItem List+ Tariff IndicatorTariff = trueTariff DisruptionListNumberformatConnectto SharePointNode 1342Column Filter Column Rename DB Query Reader String to Date&Time String Manipulation(Multi Column) Rule Engine Column Filter Cell Splitter Column Rename DB Query Reader Ungroup String To Number Row Filter Column Filter Sorter Column Filter Row Filter Joiner Folder >Latest File Column Filter Date&Time-basedRow Filter PostgreSQLConnector DB Table Creator DB Loader DB SQL Executor DB Writer GroupBy Table Rowto Variable Joiner Column Rename DB Writer Excel Reader Excel Reader Excel Reader Column Filter Column Filter Column Filter Column Rename Column Rename Column Rename Concatenate ConstantValue Column ConstantValue Column ConstantValue Column Column Expressions Row Filter Column Filter Column Filter Joiner DB Writer Rule-basedRow Filter Sorter DuplicateRow Filter String Manipulation(Multi Column) String Manipulation(Multi Column) Rule Engine Rule-basedRow Splitter Joiner Column Expressions Row Filter Row Filter Column Resorter Column Expressions Column Filter Joiner Concatenate Joiner GroupBy Row Filter ZIP ArchiveConnector File Reader(Complex Format) List Files/Folders Table Rowto Variable ConstantValue Column ConstantValue Column Concatenate Column Rename Column Rename Column Filter Concatenate DB SQL Executor DB SQL Executor DB SQL Executor Create File/FolderVariables DuplicateRow Filter DB Query Reader PostgreSQLConnector PostgreSQLConnector CSV Writer Column Rename Rule-basedRow Filter Google BigQueryConnector GoogleAuthentication DB Query Reader Joiner DB SQL Executor DB Loader DB Table Creator DB Query Reader Joiner Table Creator Joiner Column Expressions Column Filter Cell Splitter String To Number Ungroup Column Expressions Column Filter DB Table Creator DB Loader DB SQL Executor DB Query Reader DB Table Creator DB Loader DB SQL Executor PostgreSQLConnector DB Writer DB SQL Executor DB Query Reader GroupBy DB Query Reader Table Row ToVariable Loop Start Loop End Joiner Column Filter Column Resorter Sorter DB SQL Executor DB Loader DB Table Creator Rule-basedRow Filter String Manipulation(Multi Column) Column Filter Cell Splitter String To Number Ungroup Column Expressions DB Query Reader DB Query Reader CSV Writer Column Rename CSV Writer Column Filter Column Rename Joiner ConstantValue Column Column Rename Excel Reader Column Expressions SharePointOnline Connector MicrosoftAuthentication 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 SharePointConnector Write to GCP Parse item list Determine if Item/Store already storedfor ALT ID- TRUE - No action needed (skip)- FALSE - Determine item and store listand load data ALT Location Override(ONLY if algorithm does not determinecorrectly) GCP Connector Current Stock Statusto GCP and PostgreSQL Sales Data toGCP ALT Assistant GPTFile Creation Keep onlyneeded columnsRenameto DB namesGCP - Current Stock IDCSubmittedto date typeTrim whitespace& lowercaseStandardizeALT requesttypeStockrequestsSplit outdelimited itemsRenameGCP - Store DetailsItem to numberFilter outnon-numbersand zeroesNon-stockrequestsFilter to high-level request info Assortmentedits onlyCombineOnly neededcolumnsFY 2025 and later onlyPostgreSQL(prod - read/write)temp_alt03_approvalsInsert to prod;clean upLoad ALTRequest Info to tempUnique itemlistCombineDB NamesWrite totempStockNon-StockCOOKeep NeededColumnsKeep NeededColumnsKeep NeededColumnsRenameRenameRenameMergeAdd"stock"columnAdd "non-stock"columnAdd "stock"columnFix Reset IDto RESET######Filter torows w/ ResetFilter out Reset IDcolumnJoinLoad ALTapproval Info to tempFilter blanksRemove dupesTrimwhitespaceRemoveweird charactersNon-stockif missingCheck ifstore is blankDistrict-to-storeRemove whitespaceRemove characters from comments(see node for moredetails)Store Match= TrueDistrict Match= TrueDeterminestore or districtmatch(see node for moredetails)Filterfor DB additionRequestsw/o store matchesCombineNo store ordistrict matchManual reviewFilter out blankcommentsConnectto ZIP fileRead CSVfrom ZIPSelect CSV fileAdd "non-stock"columnAdd "stock"columnMergeRenameRenameFilterfor DB additionMergeInsert to prodClean upInsert to prodClean upInsert to prodClean upRemove dupesItem ListPostgreSQL(prod - read/write)PostgreSQL(prod - read/write)item_list.csvOnly ApprovedRequestsBigquery ConnectorSign in with your GCP AccountRFM Sales IDAdd RFM Sales IDInsert to prod;clean uptemp_alt01_request_detailPull ALT ID'salready storedRemove ALT ID'salready parsedALT LOCATIONMANUAL OVERRIDEReplace storelist (if needed)Revelant columnsSplit outdelimited storesStore to numberFormatcolumnsRemoveArray Columntemp_alt02_item_store_actionInsert to prod;clean upGCP - Pull ALTitem/store combostemp_alt02_item_store_action_statusInsert to prod;clean upPostgreSQL(prod - read/write)Write totempInsert to prod;clean upPull approveditem/store/for approved stock requestsMeasure Date =last date sales was pulledor reset completion/end dateUnique listGCP > Sales Databy WeekLoop StartLoop EndJoin toALT ID, Item, StoreInsert to prod;clean uptemp_alt06_salesFilter out 0and wrong datesNode 1323RemoveArray ColumnSplit outdelimited districtsDistrict to numberFormatcolumnsStore ListTracking& Measurementstore_list.csvtracking_measurement.csvItem onlyItem List+ Tariff IndicatorTariff = trueTariff DisruptionListNumberformatConnectto SharePointNode 1342Column Filter Column Rename DB Query Reader String to Date&Time String Manipulation(Multi Column) Rule Engine Column Filter Cell Splitter Column Rename DB Query Reader Ungroup String To Number Row Filter Column Filter Sorter Column Filter Row Filter Joiner Folder >Latest File Column Filter Date&Time-basedRow Filter PostgreSQLConnector DB Table Creator DB Loader DB SQL Executor DB Writer GroupBy Table Rowto Variable Joiner Column Rename DB Writer Excel Reader Excel Reader Excel Reader Column Filter Column Filter Column Filter Column Rename Column Rename Column Rename Concatenate ConstantValue Column ConstantValue Column ConstantValue Column Column Expressions Row Filter Column Filter Column Filter Joiner DB Writer Rule-basedRow Filter Sorter DuplicateRow Filter String Manipulation(Multi Column) String Manipulation(Multi Column) Rule Engine Rule-basedRow Splitter Joiner Column Expressions Row Filter Row Filter Column Resorter Column Expressions Column Filter Joiner Concatenate Joiner GroupBy Row Filter ZIP ArchiveConnector File Reader(Complex Format) List Files/Folders Table Rowto Variable ConstantValue Column ConstantValue Column Concatenate Column Rename Column Rename Column Filter Concatenate DB SQL Executor DB SQL Executor DB SQL Executor Create File/FolderVariables DuplicateRow Filter DB Query Reader PostgreSQLConnector PostgreSQLConnector CSV Writer Column Rename Rule-basedRow Filter Google BigQueryConnector GoogleAuthentication DB Query Reader Joiner DB SQL Executor DB Loader DB Table Creator DB Query Reader Joiner Table Creator Joiner Column Expressions Column Filter Cell Splitter String To Number Ungroup Column Expressions Column Filter DB Table Creator DB Loader DB SQL Executor DB Query Reader DB Table Creator DB Loader DB SQL Executor PostgreSQLConnector DB Writer DB SQL Executor DB Query Reader GroupBy DB Query Reader Table Row ToVariable Loop Start Loop End Joiner Column Filter Column Resorter Sorter DB SQL Executor DB Loader DB Table Creator Rule-basedRow Filter String Manipulation(Multi Column) Column Filter Cell Splitter String To Number Ungroup Column Expressions DB Query Reader DB Query Reader CSV Writer Column Rename CSV Writer Column Filter Column Rename Joiner ConstantValue Column Column Rename Excel Reader Column Expressions SharePointOnline Connector MicrosoftAuthentication

Nodes

Extensions

  • No modules found

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-08-01
Created with KNIME version: v4.7.8

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

Try NodePit Runner!