Hi Experts,
Can you please help me in solving this. If in similar Company code, Emp Name is appearing 2 times so we need to choose only Fixed type row.
| Company Code | Name | Type |
| 101 | Alex | Fixed |
| 101 | Alex | Variable |
| 121 | Nemo | Variable |
| 120 | Micheal | Variable |
| 123 | Act | Fixed |
| 121 | Nemo | Fixed |
Output-
| Company Code | Name | Type |
| 101 | Alex | Fixed |
| 120 | Micheal | Variable |
| 123 | Act | Fixed |
| 121 | Nemo | Fixed |
