App Development

Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY

Who Me Too'd this topic

jdean1012
Contributor III
Contributor III

Dual Field Dimension is Displaying the NUMBER instead of TEXT

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];

 
 

dual problem.PNG

Labels (1)
Who Me Too'd this topic