Dual field

[DSDD]

Dear Community,

i want to define a field in load-script as dual, expecting that with this step i may assign ordering of a field.

My try:

When i display that in a table, i get

not what i expected. When i want to define master-item, doubled categories as well

How do i achieve a working dual-assignment, WITHOUT using several IF-Conditions?

Thanks for your help

[skamath1 · Accepted solution]

Really not clear with your requirements. Assuming you want to sort on the cat_sales in S, M, L and XL.

You can use mapping 

MapTemp:
Mapping
Load * inline [
NameScat, NumScat
S,0
M,1
L,3,
XL,4
] ;

Load
iln as key_iln,
corp,
Dual(sales19_class,ApplyMap('MapTemp',sales19_class,0)) as cat_sales
From data