Want to display ids with respect to min(date) and bucket .

[kavita25]

Hello everyone ,

I have table like this 

Id.    bucket         Date.          Collection value  

1.    90 to 120       01/02/19   500

1.    150to 180.    01/04/19.   600

1.    150to 180.    01/05/19.  0

2.    150to 180.    01/02/20. 600

2.    180to210      01/06/19.  800

3.     90 to 120.    01/07/19. 6000

3.     180 to 210. 01/08/19.  500

3.    400+.             01/09/19.  300

Expected output 

Id.    bucket         Date.          Collection value  

1.    90 to 120       01/02/19   500

2.     180 to 21.    01/06/19.   800

3     90 to 120.    01/07/19.  6000

I want to display only Id of minimum date and there minimum bucket and there corresponding collection value 

I want to do this on backend .

Any solution will be appreciated 

Regards ,

Kavita 

[sunny_talwar · Accepted solution]

Try something like this

Table:
LOAD Id,
     bucket,
     Date,
     [Collection value]
FROM ...;

Right Join (Table)
LOAD Id,
     Min(Date) as Date
Resident Table
Group By Id;