I am using correct script??

[harleen_singh]

I don't know where i am wrong in this script??

LOAD date,

     v,

     Max(date) as maximumdate

FROM

table

thanks

Lavi

[#2]

Hi,

   Check with 'Group By"

-Jai

[harleen_singh]

I have used this

LOAD date,

     v,  

     Max(date) as maxidate

FROM

table

Group by date;

it didn't worked

[#4]

Hi,

the load statement should be like this:

LOAD date,

     v,

     Max(date) as maximumdate

FROM

table

Group by date, v;

Cheers.

[harleen_singh]

blackrocks

               you are correct but max function is not retrieving maximum date its displaying all dates as usual.

thanks

[#6]

Hi,

is it possible for you to attach sample data that you are loading.

[#7]

Hi,

Check with the appln

-Jai

[kaushiknsolanki]

Hi,

    Remove the date field if you want only max(date) and the value of v.

    something like this.

    load v,max(Date) as MaxDate

     from table

    group by v;

    If you just want to have max(date) which is not linked to the table. then try this.

   load max(Date) as MaxDate

   from table

Regards,

Kaushik Solanki

[harleen_singh]

Black Rocks

its simple

date         v

10/7/2011  1

11/7/2011  2

12/7/2011  3

[harleen_singh]

I want to display maximum date as well as all dates as well as all values(v).

thanks