10 Replies Latest reply: May 6, 2016 12:47 PM by Tamil Nagaraj RSS

    Invalid expression Error for different statments..

    Alluraiah Allu

      Hi,

      I am getting Invalid expression for some times and sometimes not ;

       

      please advise me , did i miss anything in error table ?

       

      //Following throws    NO ERROR

      TEMP1:

      LOAD * INLINE [

          Country, Value, SalesDate

          USA, 12, 2013-01-04

          USA, 14.5, 2013-02-07

          USA, 6.6, 2013-03-03

          USA, 4.5, 2013-04-11

          USA, 7.8, 2013-05-19

          USA, 9.4, 2013-06-22

          UK, 11.3, 2013-01-31

          UK, 10.1, 2013-02-01

          UK, 3.2, 2013-03-21

          UK, 5.6, 2013-04-15

          UK, 3.9, 2013-05-12

          UK, 6.9, 2013-06-06

      ];

       

      MINMAX:

      LOAD

      month(date#(SalesDate,'YYYY-MM-DD')) as monthdate

      Resident TEMP1;

      DROP TABLE TEMP1;

       

       

       

      /////FOLLOWING THROWS INVALID EXPRESSIONS

       

      TEMP1:

      LOAD * INLINE [

          Country, Value, SalesDate

          USA, 12, 2013-01-04

          USA, 14.5, 2013-02-07

          USA, 6.6, 2013-03-03

          USA, 4.5, 2013-04-11

          USA, 7.8, 2013-05-19

          USA, 9.4, 2013-06-22

          UK, 11.3, 2013-01-31

          UK, 10.1, 2013-02-01

          UK, 3.2, 2013-03-21

          UK, 5.6, 2013-04-15

          UK, 3.9, 2013-05-12

          UK, 6.9, 2013-06-06

      ];

       

      MINMAX:

      LOAD

      month(date#(SalesDate,'YYYY-MM-DD')) as monthdate,

      Max(date#(SalesDate,'YYYY-MM-DD')) as maxdate

       

      Resident TEMP1;

      DROP TABLE TEMP1 ;