Icon

CTC Scorecard

Reset this Node toGenerate File name Execute this Node tocreate new Inventoryfile Reset this Node to Process NewInventory Files Reset this Node to Process New POSFiles Execute this Node tocreate new POS file DO NOT TOUCH THESE NODES Promo CalendarConvert Date to StringRead All File Namesin POS FIles folderCombine WeeklyfilesAdd Promo WeeksJoin with YA dataWrite new data fileNode 76Group byitem#/Store#/WeekRename columnsConvert missingsales data to 0Remove YAweekNode 143Node 144Node 162Inventory FilesNode 165Write new data filePrevious POS DataCombine newestweek data withprevious dataNode 178Previous Inventory DataCombine newestweek data withprevious dataNode 181Node 182 Excel Reader (XLS)(deprecated) Date&Time to String List Files Historical Data Joiner Joiner CSV Writer Date&Time Input GroupBy Column Rename Missing Value Column Filter Collect YA Data Generate File Name Combine withYA Data Historical Data List Files CSV Writer File Reader Concatenate CSV Writer File Reader Concatenate CSV Writer Column Filter Reset this Node toGenerate File name Execute this Node tocreate new Inventoryfile Reset this Node to Process NewInventory Files Reset this Node to Process New POSFiles Execute this Node tocreate new POS file DO NOT TOUCH THESE NODES Promo CalendarConvert Date to StringRead All File Namesin POS FIles folderCombine WeeklyfilesAdd Promo WeeksJoin with YA dataWrite new data fileNode 76Group byitem#/Store#/WeekRename columnsConvert missingsales data to 0Remove YAweekNode 143Node 144Node 162Inventory FilesNode 165Write new data filePrevious POS DataCombine newestweek data withprevious dataNode 178Previous Inventory DataCombine newestweek data withprevious dataNode 181Node 182 Excel Reader (XLS)(deprecated) Date&Time to String List Files Historical Data Joiner Joiner CSV Writer Date&Time Input GroupBy Column Rename Missing Value Column Filter Collect YA Data Generate File Name Combine withYA Data Historical Data List Files CSV Writer File Reader Concatenate CSV Writer File Reader Concatenate CSV Writer Column Filter

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: cai.c.8
Created at: 2021-07-30
On NodePit since: 2023-11-03
Last update: 2024-04-27
Created with KNIME version: v4.1.4

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

Try NodePit Runner!