DarwinCastro Posted April 6 Report Share Posted April 6 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. Quote Link to comment Share on other sites More sharing options...
0 CoopperBackpack Posted April 6 Report Share Posted April 6 Hello @DarwinCastro, If Tasks are included in your plan, you may test the Task with the following design: Hope this helps! Quote Link to comment Share on other sites More sharing options...
0 DarwinCastro Posted April 6 Author Report Share Posted April 6 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 Quote Link to comment Share on other sites More sharing options...
0 NiceDuck Posted April 6 Report Share Posted April 6 Try Grouping it by 'Observation' only Quote Link to comment Share on other sites More sharing options...
0 DarwinCastro Posted April 7 Author Report Share Posted April 7 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) Quote Link to comment Share on other sites More sharing options...
0 CoopperBackpack Posted April 7 Report Share Posted April 7 @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. Quote Link to comment Share on other sites More sharing options...
Question
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.
Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.