Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
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
];
Thank you!