Table Formatting Download

[hanna_choi]

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