Dual field

DSDD — Sat, 16 Nov 2024 17:32:12 GMT

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

Re: Dual field

skamath1 — Wed, 03 Feb 2021 02:22:09 GMT

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