I want to remove duplicate ID with type 2,as per below senario
Input
id type
1 1
2 2
3 3
3 2 -> To be removed for duplicate Id = 3
4 3
4 2 -> To be removed for duplicate Id = 4
5 5
output
id type
1 1
2 2
3 3
4 3
5 5
Shall apprciate your help in putting this logic in datastage.
Remove duplicate with certain type
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: