Icon

National_​Op_​ETL

INST_BU
GroupBy
INS_NS_BILLING
Joiner
Joiner
Unpivot
Joiner
Column Renamer
Row Filter
SOURCE_F
Component
INS_NS_BILLING_SUM
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
NS_STACK_VALUES
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
Lkup_Suffix
Excel Reader
Export_SSA_National_WS_Operator
Excel Writer
SSA_WS_National_Operator_Data
Component
ACCOUNT_SRC
Component
Rule-based Row Filter
Cross Joiner
VAA_STACK_ATTRIBUTE_FILTER
Component
Rule Engine
ACCOUNT_DEST
Component
SCENARIO
Excel Reader
NS_SUFFIX
Concatenate
Cross Joiner
NS_SUFFIX_2
Row Filter
INST_NS_BPS
Rule Engine
GroupBy
Column Filter
VAA_FINAL
Component
Row Filter
VAA_APPEND
Component
NS_CO
Column Renamer
ACCOUNT_ASSIGNMENT
Concatenate
DRIVER_NAMES
Component
Joiner
Map VAA National Operator
Excel Writer
VAA_STACK_CONVERSION_FILTER
Component
Distance WS National Export
Excel Writer
VAA_STACK_MEASURE_FILTER
Component
Rule Engine
Math Formula
String to Number
Column Filter
DIMREFS_G
Excel Reader
Row Filter
Row Filter
DIMREFS_F
Excel Reader
Joiner
NS_PART1
Concatenate
VAA_NATIONAL_OPERATOR
Excel Writer
NS_CT
Column Renamer
ACCOUNT_VAA
Component
NS1
Rule Engine
MM_WS_NATIONAL_OPERATOR
Excel Writer
Joiner
MM_ARBOR_FIXED_INST
Joiner
QUERY_FOR_MM_ARBOR_FIXED_INST
Column Filter
NS_NS_F
GroupBy
MM_ARBOR_FIXED_INST_0000
Column Filter
Duplicate_MM
GroupBy
National_Operator_Map
Excel Reader
Row Filter
Joiner
Column Renamer
Column Filter
String Manipulation
GroupBy
String Manipulation
Column Resorter
Expression
String Manipulation
Row Filter
Column Filter
Assignment_B_C
Component
INST_SUFIX
Expression
INST_MAPPING
Rule Engine
SOURCE_C
Component
Column Filter
REVENUE_DATA_ONLY
Row Filter
Joiner
National_Operator_VAA
Excel Reader
Column Renamer
Assignment_C_D
Component
Source_B
GroupBy
LKUP_PERIOD
Component
Joiner
LKUP_CATEGORY
Component
SOURCE_D
Component
BPS_NS
Column Filter
LKUP_DRIVERNAMES_STAGES
Component
Assignment_D_E
Component
Arbor_Postpaid_Suffix_1
Duplicate Row Filter
Column Name Replacer
String Manipulation
String Manipulation
Column Filter
ACCOUNT_POOLS_A_B
Excel Reader
BILLING_AFIX
Column Resorter
Joiner
Column Renamer
BPS_BU
Component
DIMREFS
Excel Reader
SOURCE_E_1
Column Renamer
Row Filter
Column Filter
Joiner
Column Filter
Joiner
Revenue_Data_AFIX
GroupBy
NS_STACK_VALUES_FOR_VAA
GroupBy
Column Filter
Column Filter
Row Filter
NS_SUFFIX_1
GroupBy
SOURCE_E
Concatenate
SOURCE_E_2
Component
Row Filter
Assignment_E_F
Component
Joiner
National Operator Data
Excel Reader

Nodes

Extensions

Links