7 Replies Latest reply: Jul 5, 2016 2:02 AM by Chanty 4u RSS

    Null values in dimension

    Kshitija Shinde

      Hello,

       

      I want AC BC as dimension but getting null values .

       

      Here is the following code i have used and the result which m getting:

      [Sheet1]:

      LOAD

      [Sr. No],

      [Date of Receipt],

          Date(Date#([Date of Receipt], 'dd MMM yyyy hh:mm:ss:fff'), 'M/d/yyyy hh:mm:ss tt') as new_Date,

       

      table1:

      Load

      [Sr. No],

      [Date of Receipt],

          new_Date,

          month(new_Date) as new_month,

          Resident [Sheet1];

          Drop Table [Sheet1];


      Table5:

      Load*Inline

      [new_month,Check

      Jul,BC

      Aug,BC

      Sep,BC

      Oct,BC

      Nov,BC

      Dec,AC

      Jan,AC

      Feb,AC

      Mar,AC

      Apr,AC];

       

      image.png

       

      Can anyone suggest whats going wrong ?

       

      Thanks in advance!!