5 Replies Latest reply: Mar 14, 2012 12:08 AM by Arun Goel RSS

    Problem in quarter mapping (inline)

    Arun Goel

      hi,

      i was trying to create quarter by loading inline table as:

       

       

       

      LOAD * INLINE [
      
          Half, MONTH_NUM, MONTH, QUARTER
          1,1, Jan, Q1
         1, 2, Feb, Q1
         1, 3, Mar, Q1
         1, 4, Apr, Q2
        1,  5, May, Q2
       1,   6, Jun, Q2
        2,  7, Jul, Q3,  
        2,  8, Aug, Q3,
        2,  9, Sep, Q3,
         2, 10, Oct, Q4,
         2, 11, Nov, Q4,
         2, 12, Dec, Q4,
      ];
      
      

      and  map it to xl which contains a field date1

       

      LOAD Date(Date1) as DATE,
      
      
      Month(Date1) as MONTH
      FROM
      map.xlsx
      (ooxml, embedded labels, table is Sheet1);
      
      

       

       

      when i see table viewer , mapping is done perfectly but i am getting strange result.

      the resultant MONTH field looks like:-

       

      MONTH.PNG

       

       

      but table viewer showing mapping correctly...

      Capture.PNG

       

      I have attached my QVW and XL file....PLz help.......