Icon

National_​Op_​ETL

INST_BU
GroupBy
Joiner
Joiner
Unpivot
Joiner
Column Renamer
Row Filter
SOURCE_F
Component
GroupBy
Joiner
SOURCE_G
Component
Math Formula
Assignment_F_G
Component
GroupBy
Assignment_G_H
Component
NS_STACK_VALUES_FOR _VAA
Column Filter
Column Resorter
Joiner
BPS_BU
Column Filter
Joiner
NS_NS_F
Column Filter
Joiner
DIMREFS_H
Excel Reader
Column Renamer
Cross Joiner
Constant Value Column Appender
String Manipulation
GroupBy
Assignment_Part
Concatenate
Row Filter
Column Filter
GroupBy
GroupBy
String Manipulation
String to Number
Joiner
String Manipulation
VAA_F_CO_PART_1
Component
VAA_G_BPS_PART1
Component
VAA_H_FPS_PART1
Component
Cross Joiner
Joiner
Export_SSA_National_WS_Operator
Excel Writer
SSA_WS_National_Operator_Data
Component
ACCOUNT_SRC
Component
Rule-based Row Filter
Cross Joiner
Rule Engine
ACCOUNT_DEST
Component
SCENARIO
Excel Reader
NS_SUFFIX
Concatenate
Cross Joiner
NS_SUFFIX_2
Row Filter
Rule Engine
GroupBy
Column Filter
VAA_FINAL
Component
Row Filter
VAA_APPEND
Component
Column Renamer
ACCOUNT_ASSIGNMENT
Concatenate
DRIVER_NAMES
Component
Map VAA National Operator
Excel Writer
Distance WS National Export
Excel Writer
Rule Engine
Math Formula
String to Number
Column Filter
DIMREFS_G
Excel Reader
Row Filter
DIMREFS_F
Excel Reader
Concatenate
VAA_NATIONAL_OPERATOR
Excel Writer
Column Renamer
ACCOUNT_VAA
Component
Rule Engine
MM_WS_NATIONAL_OPERATOR
Excel Writer
Joiner
MM_ARBOR_FIXED_INST
Joiner
VAA_STACK_SUMMARY
Component
Column Renamer
QUERY_FOR_MM_ARBOR_FIXED_INST
Column Filter
NS_NS_F
GroupBy
MM_ARBOR_FIXED_INST_0000
Column Filter
Source_B
GroupBy
Column Filter
Duplicate_MM
GroupBy
Joiner
IMPORT_INST_DATA
Component
INST_MAPPING
Component
Assignment_B_C
Component
SOURCE_C
Component
Joiner
Assignment_C_D
Component
LKUP_PERIOD
Component
Joiner
LKUP_CATEGORY
Component
SOURCE_D
Component
BPS_NS
Column Filter
LKUP_DRIVERNAMES_STAGES
Component
Assignment_D_E
Component
LKUP_SUFFIX
Component
Column Name Replacer
String Manipulation
String Manipulation
Column Filter
BILLING_AFIX
Column Resorter
Joiner
Column Renamer
BPS_BU
Component
DIMREFS
Excel Reader
SOURCE_E_1
Column Renamer
Joiner
Account_Pool_B
Component
Column Filter
Column Filter
Joiner
Revenue_Data_AFIX
GroupBy
NS_STACK_VALUES_FOR_VAA
GroupBy
Column Filter
Revenue_Data Only
Row Filter
Column Filter
NS_SUFFIX_1
GroupBy
SOURCE_E
Concatenate
SOURCE_E_2
Component
Assignment_E_F
Component
Joiner

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: 70360
Created at: 2025-11-18
On NodePit since: 2025-12-05
Last update: 2025-12-05
Created with KNIME version: v5.8.0

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

Try NodePit Runner!