Dear.
I need to list the departments in order.
The organization order was defined by a mapping table.
Organizations that are not in the organization mapping table have string values.
It was grouped into Dual values.
*** sample data ****
Order_Map:
mapping Load *
inline [
Dept, Order
Dept_AB, 1
Dept_AA, 2
]
;
Sales_TEMP:
LOAD *
inline [
Dept, Values
Dept_A, 10000
Dept_AA, 12000
Dept_B, 10000
Dept_AB, 13000
Dept_C, 10000
];
Sales:
Load
*,
applymap('Order_Map',Dept ) as Order,
dual(Dept, applymap('Order_Map',Dept )) as Order_1
resident Sales_TEMP;
drop table Sales_TEMP;
**************************
when you export data as table formatting , the following occurs:
The Result :
How can I solve this problem?
Best Regard
hanna.choi