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:
![table formatting.png table formatting.png](https://community.qlik.com/t5/image/serverpage/image-id/162161iBDC59098A4D16823/image-size/medium?v=v2&px=400)
The Result :
![the result.png the result.png](https://community.qlik.com/t5/image/serverpage/image-id/162162i83AB2566B5256217/image-size/medium?v=v2&px=400)
How can I solve this problem?
Best Regard
hanna.choi