Issue with firstsortedvalue

[#1]

Hi Friends,

I'm struck with some issue related to firstsortedvalue.

I wrote a statement in my script like

firstsortedvalue(ID,-Time) as UserID----- This statement will return the id of the user based on the latest time.

firstsortedvalue(ID,Time) as UserID--- This statement will return the id of the user based on the earliest  time.

But what I want is all the users who has done some particular task based on my where clause.

so I also tried just

ID as UserID--- But it is giving me all the data, wrt other users also.

Can you help me in this.

Thanks,

Sindhu

[Anonymous]

Hi, SIndhu,

I think it is possible that Where clause is ignored with LOAD directly, see same problem here .

You can try first load the whole table as table_temp, and then use:

Left join(..)

Load

...

Resident table_temp

Where

from_task='Start'

and to_task='Build';