Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone please help me in creating an ApplyMap function and InLine table for the below case expression.
CASE
When ([MRN_CTG_NM]~="Target") and ([IDX_FND_IN]=0) then "Plan Using RDFs"
When ([MRN_CTG_NM]~="Target") and ([IDX_FND_IN]=1) then "Plan Using RDFs"
ELSE
"Plans Without RDFs"
End
Thanks,
-Vidya
ApplyMap works strictly for translaltion of code to description, e.g. 1 = male, 2 = female.
If the translation is conditional on multiple fields it is done in the sql as shown or if statements in the LOAD
ApplyMap works strictly for translaltion of code to description, e.g. 1 = male, 2 = female.
If the translation is conditional on multiple fields it is done in the sql as shown or if statements in the LOAD
Any reason that something like this wouldn't work? If((Match(Upper([MRN_CTG_NM]),'TARGET') and Match([IDX_FND_IN],0,1)), 'Plan Using RDFs','Plans Without RDFs')
Thanks, David.
Should work in a LOAD statment or UI as a dimension / variable formula