Show value in pivot table

Sun, 27 Nov 2011 16:09:27 GMT

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.

Re: Show value in pivot table

Miguel_Angel_Baeyens — Sun, 27 Nov 2011 17:09:45 GMT

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