Table Formatting Download

hanna_choi — Mon, 18 Mar 2024 02:11:38 GMT

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

topic Table Formatting Download in Management & Governance