Show value in pivot table

[#1]

Dear all,

I have a value like this

DelinquentStatus = '0'.,'1','2','3','4','5','6','7','8','9','10','11','12'

By the way, I'd like show DelinquentStatus in my pivot table like this: 'MOB0','MOB1','MOB2','MOB3',...,'MOB12'

How can I change these value?

Thank you very much for your help.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

You can easily create a mapping table or a Dual() field in your LOAD, something like

Map:
MAPPING LOAD * INLINE [
Num, String
0, MOB0
1, MOB1
2, MOB2
... // and so on
];
Data:
LOAD DelinquentStatus,
     Field2,
     ApplyMap('Map', DelinquentStatus) AS DelinquentStatus_String,
... // Rest of your script here

Hope that helps

Miguel