3 Replies Latest reply: Jan 24, 2018 3:42 AM by Minh-Tri Truong RSS

    Applymap Question

    Minh-Tri Truong

      Hello,

      I am driving nuts...

      Any clue why I do not get any result from the ApplyMap? the result is not found and it does not even display 'missing'...

       

      Applymap('Map_DiscountedSeason',Floor(MonthStart(DateId),1),'missing') as DiscountedCollection

      (with DateId='01/01/2018')

      Also, I would like to stress that Floor(MonthStart('01/01/2018'),1)=43101 which is also the value I see when I check the Map using the view panel.

      Thank you in advance,

      MT

       

       

      File :

      TimeFrame;DiscountedSeason

      2018-1;0

      2018-1;0

       

      Map_DiscountedSeason:

      LOAD Num(Date#(TimeFrame, 'YYYY-MM')) As Month,

          [DiscountedSeason]

      FROM [$(folderData)/SeasonToBeDiscounted.csv]

      (txt, codepage is 1252, embedded labels, delimiter is ';', msq);