Apply Map Issue

[wassimharfoush]

Hi,

Can someone helps me and figure out why apply map is not  working in the attached Qvw.

Thank you for your help!

Best Regards,

Wassim

[Clever_Anjos · Accepted solution]

It seems to be a conversion of number to text

Use this to create your mapping

FYMonthsNames:

Mapping LOAD text(RevenueMonth),RevenueMonthName INLINE [

    RevenueMonth,  RevenueMonthName 

    01,  Jul

    02,  Aug

    03,  Sep

    04,  Oct

    05,  Nov

    06,  Dec

    07,  Jun

    08,  Feb

    09,  Mar

    10,  Apr

    11,  May

    12,  June

    ];

[wassimharfoush]

Thank you!