- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Team,
I want to filter out some records based on the below conditions.
example:
Input records:
| customer id | customer type | Date |
| 1 | Full time | 01-01-2016 |
| 1 | Full time | 01-01-2018 |
| 1 | Full time | 03-01-2020 |
| 1 | Part Time | 04-01-2021 |
| 1 | Part Time | 01-01-2015 |
| 2 | Full time | 06-01-2016 |
| 2 | Part Time | 01-01-2019 |
| 3 | Full time | 08-01-2016 |
| 3 | Part Time | 12-01-2016 |
| 3 | Part Time | 10-01-2017 |
| 3 | Part Time | 18-01-2021 |
| 4 | Full time | 12-01-2016 |
Output records expected:
On first run:
| customer id | customer type | Date |
| 1 | Full time | 01-01-2016 |
| 1 | Full time | 01-01-2018 |
| 1 | Full time | 03-01-2020 |
On second run:
| customer id | customer type | Date |
| 1 | Part Time | 04-01-2021 |
| 1 | Part Time | 01-01-2015 |
On third run:
| customer id | customer type | Date |
| 2 | Full time | 06-01-2016 |
Etc
So basically i want a filtering technique which will filter out all the records for that particular customer with same customer type.
I tried with deduplication but only the latest one or any random one is coming.
Could someone please help me in this?
Thanks ®ards
Greeshma
Solved! Go to Solution.
Views
Replies
0 Likes
Total Likes