How to get the latest record for each id?

Question

For example, consider the following set of data rows:

ID          Attribute1          
1            25                    
1            16  
3            45      
2            34                  
1            35    
2            54   
3            33

What operator should I use to get the latest value as shown below?
  Exp:
 ID          Attribute1          
1            35      
2            34                    
3            33

Telcontar120 · Answer

It also depends on what you mean by "latest" value.  If you mean that the records are continuously inserted in your data in some kind of chronological order, you can also use Generate ID (this will simply generate a new id column that is numbered sequentially) and then use Aggregate to group by your original ID and take the max of the new ID.  This can then be used to join back to your original dataset to retrieve only the records you want.

lionelderkrikor · Answer

Hi @tayjy_wp16, You can use a Sort operator and then a Loop Values operator associated to Filter Examples and Filter Example Range operators : Here the process : Hope this helps, Regards, Lionel

kayman · Answer

The sort operator. 
Sort on Attribute1 descending.

If you need to filter out the latest value you can then use the filter example range operator, and add 1 for first and last example.