Max date data of a field

[himabinduch]

Hi There 

I have data like below

ID,Date,Id_ladder

1,022023,level1

1,032020,level0

1,052023,level2

2,032023,level1

3,012020,level0,

3,122022,level1

Now i want max date for each record with all the fields the out put should be like below

And i want it to be filyered in thesxript level it self

Id,Date,ID_ladder

1,052023,level2

2,032023,level1

3,122022,level1

Thanks,

Hima Bindu CH.

[Mark_Little]

Hi 

MAX:

Load 

ID,

Max(Date) AS [Max Date]

Resident Table

GROUP By ID;

LEFT JOIN(MAX)

LOAD

ID,

Date as  [Max Date],

ID_ladder as [Max ID_ladder]

resident Table;

Table being your original table name