I need to select the most current records (oldest date) and save them in a table

[DarwinCastro]

Hello, I have a table with N records, where I have a field that is repeated on occasions.

I need to select the most current records (oldest date) of each identifier and save them in a table, so that I have something like this:

I need to save only 1 value per identifier and that is the one with the most current date.

I am thankful for any kind of help.

 

 

[CoopperBackpack]

Hello @DarwinCastro,

If Tasks are included in your plan, you may test the Task with the following design: 

Hope this helps!

[DarwinCastro]

1 hour ago, CoopperBackpack said:

Hello @DarwinCastro,

If Tasks are included in your plan, you may test the Task with the following design: 

Hope this helps!

thanks, I tried but I insert all the records, not just the record with the oldest date

[NiceDuck]

Try Grouping it by 'Observation' only

[DarwinCastro]

9 hours ago, CoopperBackpack said:

Hello @DarwinCastro,

If Tasks are included in your plan, you may test the Task with the following design: 

Hope this helps!

thanks, I tried but I insert all the records, not just the record with the oldest date

 

when I run the task like this, it brings me the largest record of each ID:

But I need to save the values of the other fields, for example the observation. If I add it inside the group by, it brings me all the records, not just the largest one (as I need it)

[CoopperBackpack]

@DarwinCastro,

I created the same table as on your screenshot in my account:

 

After the Task run I received the following result:

 

Since each ID corresponds to the specific Observacion, the Task should select 1 record for each ID and this is the record with the maximum (the most recent) date. 

Maybe I missed something in your description. For me Task works as expected.