Dual Field Dimension is Displaying the NUMBER instead of TEXT

[jdean1012]

I have a dual field mapping that a text field into a dual text/number field.

When I add the resulting dual field to a straight table as a dimension, it is showing the number instead of the text.

How do I make it display the text?

[SpendOppBreakdown_RAW]:
Load *
Inline
[
SpendOppBreakdown_RAW
"Managed"
"Retired"
"Opportunity"
"Delegated"
"BU Managed"
"Direct Spend"
"Non Addressable"
"Overlapping Data"
];

[SpendOppBreakdown_MAP]:
Mapping
Load
[SpendOppBreakdown_RAW],
If([SpendOppBreakdown_RAW] = 'Managed',Dual('Managed', 40),
If([SpendOppBreakdown_RAW] = 'Retired',Dual('Retired', 60),
If([SpendOppBreakdown_RAW] = 'Opportunity',Dual('Opportunity', 70),
If([SpendOppBreakdown_RAW] = 'Delegated',Dual('Delegated', 80),
If([SpendOppBreakdown_RAW] = 'BU Managed',Dual('BU Managed', 85),
If([SpendOppBreakdown_RAW] = 'Direct Spend',Dual('Direct Spend', 90),
If([SpendOppBreakdown_RAW] = 'Non Addressable',Dual('Non Addressable', 95),
If([SpendOppBreakdown_RAW] = 'Overlapping Data',Dual('Overlapping Data', 99),
Dual('Unknown',1000)
)))))))) as [SpendOppBreakdown]
Resident [SpendOppBreakdown_RAW];

[sunny_talwar]

You have added it as a measure or dimension? Looks like as a measure... can you try to add it as a dimension instead?

[jdean1012]

Thanks.  It is a Dimension; not a Measure.

I actually got it to work; I had a mistake in the join portion of my ApplyMap in the script.  But, I am still curious why it was displaying the number.