Hi,
Based on the sample table, I want to implement a logic.
- Same name, different policy # and same address - Goes to file 2
- Same name, different address and different policy number - The first record goes to file 1 and rest of the records go to file 2.
- All the manual should again go to the file 2.
Policy Number | New/ Renewal/ Manual | Name | Address | To process | Split |
123 | New | John Chris | 123 Oxford St | Y | File 1 |
110 | New | Mary Jane | 45 Caron ave | Y | File 1 |
111 | New | Mary Jane | 360 Caron ave | N | File 2 |
112 | Renewal | Kent Bryan | 333 Queen St | Y | File 1 |
113 | Renewal | Kayla Jan | 333 Queen St | Y | File 1 |
114 | Renewal | Jung Chen | 5 Queen St | Y | File 1 |
115 | Renewal | Jung Chen | 5 King St | N | File 2 |
116 | Manual | Ray Ban | 5 abc st | N | File 2 |
116 | Manual | Kan Can | 6 xyz st | N | File 2 |
116 | Manual | Harry Potter | 8 niagara st | N | File 2 |
116 | Manual | Rob Smith | 9 India St | N | File 2 |
116 | Manual | Tony Stark | 10 peter st | N | File 2 |
116 | Manual | John Snow | 11 sandwich st | N | File 2 |
2000 | New | Melanie Joy | 275 Rankin Avenue | N | File 2 |
2001 | New | Melanie Joy | 275 Rankin Avenue | N | File 2 |