Invalid expression Error for different statments..

[Anonymous]

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 ;

[sunny_talwar · Accepted solution]

Yes, it does seem to work

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,

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

Resident TEMP1

Group By Month(Date#(SalesDate,'YYYY-MM-DD'));

DROP Table TEMP1;