Hi,
I have a data set as shown below from which rows need to be filtered. The filter condition is multi condition where if flag is 1 for a partition (by name) then filter or select that row. However if all flag values are same then filter or pick the rows by their oldest date.
| Name | Number | date | Flag |
| Oscar | 1234567890 | 01/01/2011 | 1 |
| Oscar | 1234567890 | 01/01/2011 | 0 |
| Jane Joe | 2345678901 | 01/02/2011 | 1 |
| Jane Joe | 2345678901 | 01/02/2011 | 1 |
| Jane Joe | 2345678901 | 01/03/2012 | 0 |
| Jane Joe | 2345678901 | 01/03/2012 | 1 |
| Don Jon | 3456789012 | 03/03/2013 | 0 |
| Don Jon | 3456789012 | 03/04/2013 | 0 |
| Bill Will | 4567890123 | 04/05/2012 | 0 |
| Bill Will | 4567890123 | 04/06/2012 | 1 |
| Banner Stark | 5678901234 | 10/10/2020 | 1 |
| Banner Stark | 5678901234 | 10/11/2020 | 1 |
| Tony Bruce | 6789012345 | 10/20/2021 | 1 |
| Tony Bruce | 6789012345 | 10/20/2021 | 1 |
I need output so only specific rows are filter as shown below
| Name | Number | date | Flag |
| Oscar | 1234567890 | 01/01/2011 | 1 |
| Jane Joe | 2345678901 | 01/02/2011 | 1 |
| Don Jon | 3456789012 | 03/03/2013 | 0 |
| Bill Will | 4567890123 | 04/06/2012 | 1 |
| Banner Stark | 5678901234 | 10/10/2020 | 1 |
| Tony Bruce | 6789012345 | 10/20/2021 | 1 |
| | | | |
Thanks in Advance!
