Double As

[Chanty4u]

Hi all,

When i load below script it is givng error as   Filed not found  <Date>

how to over come dis?

Sample:

LOAD F1 as [s.no],

     F2 as [Sales Executive],

     F3 as [TopLine Achieved],

     F4 as [Gross Margin Achieved] ,

     F5 as [Top Line Target] ,

     F6 as GMTarget,

     F7 as Product,

     F8 as BranchHead,

     F9 as  Branch,

     F10 as Dept ,

     F11  as Date

//           Year(Date) as Year,

//     Month(Date) as Month,

//     Day(Date) as Day,

//     Week(Date) as Week,

//    'Q' & ceil(Num(Month(Date))/3) as Quater,

//     applyMap('FiscalQuarterMap', num(month(Date)),null()) AS FiscalQuarter

from[...];

[Anonymous]

Hi Chanty,

What is the content of FiscalQuarterMap?

Apply map is not matching anything, and you are returning null value.

Regards!

[Chanty4u]

No... its wrkng fyn now.  thanks

[Chanty4u]

thnx raj.  its wrkng fyn.

[PrashantSangle]

Hi,

In applymap() also you have to mention date#() for Date

Like you mention in other fields

Regards

[Chanty4u]

Thnaks Dreamer   and all.