I have a dataset which has some of the id's multiple and i n that case i only want the first.
For example if i have like below table i only need id 101 for type as A and not B record same with 103.
any help
| ID |
type |
lcd |
vis |
| 101 |
A |
cust |
1 |
| 101 |
B |
cust |
1 |
| 102 |
A |
cust |
2 |
| 103 |
A |
cust |
1 |
| 103 |
B |
cust |
1 |
| 104 |
A |
sal |
3 |
| 104 |
B |
sal |
4 |