Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
DSDD
Contributor III
Contributor III

Dual field

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:

DSDD_0-1612279763265.png

When i display that in a table, i get

DSDD_1-1612279825970.png

 

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

Labels (1)
1 Solution

Accepted Solutions
skamath1
Creator III
Creator III

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 

 

View solution in original post

1 Reply
skamath1
Creator III
Creator III

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