Forum Discussion
Solved
How to flag oldest data by group
Hello, I am trying to identify (include / exclude) with a flag some Email by grouping them by Email and date. Only the oldest entries by Email, need to be Exclude. Here an exemple of what I need. ...
WannaBe I just went with the names of the columns you showed in your sample data. If your column is named something else you will have to adjust. Alternatively, perhaps the actual steps will help. Get all of your transformations done that you want to clean up your data. Then do the following:
- Select Group By in the ribbon of the Home tab. Turn on Advanced. Group by Email column. Create an aggregation that returns the Minimum of Date. Create another aggregation that returns all rows.
- Expand the column that contains all rows except uncheck email column and turn off "Use original column name as prefix"
- Add a conditional column where if the minimum data aggregation column and the data column are equal to one another then return "Exclude" else return "Include"
Thank you Greg_Deckler for your help!