Los Angeles
CA
90023
Los Angeles_CA_90023
Miele international company
Miele International company
6466
Los Angeles
CA
90023
Los Angeles_CA_90023
MIELE DEPENDABLE CENTER
MIELE DEPENDABLE CENTER
18
Los Angeles
CA
90023
Los Angeles_CA_90023
MEILE DEPENDABLE DISTRI
MEILE DEPENDABLE DISTRI
16
Los Angeles
CA
90023
Los Angeles_CA_90023
LOS ANGELES SERVICE CENTER
LOS ANGELES SERVICE CENTER
9
Los Angeles
CA
90023
Los Angeles_CA_90023
DDC CALIFORNIA
DDC CALIFORNIA
4
Los Angeles
CA
90023
Los Angeles_CA_90023
Dependable Distribution Center
Dependable Distribution Center
2
Los Angeles
CA
90023
Los Angeles_CA_90023
BAY CITIES C O BARBARA
BAY CITIES C O BARBARA
1
Los Angeles
CA
90023
Los Angeles_CA_90023
MIELE DEPENDABLE
MIELE DEPENDABLE
1
Los Angeles
CA
90023
Los Angeles_CA_90023
MIELE DEPENDABLE LOGISTICS
MIELE DEPENDABLE LOGISTICS
1
Parent Company
Parent Company
Parent Company
RecordID
1
Int32
6
0
ShipperCity
Revised Name 3
V_WString
256
Empty
IF !IsEmpty([Row-1:Revised Name 3]) THEN [Row-1:Revised Name 3] ELSE [Revised Name 2] ENDIF
IF !IsEmpty([Row-1:Revised Name 3]) THEN [Row-1:Revised Name ...
RecordID - Ascending
Horizontal
find max count from each group with multi-row with fuzzy match