Hi All
I have a sequential file consists of records like (1,2,2,3,4,4,5,6,7)
I require ttwo outputs one should contain(2,2,4,4) and other should contain(1,3,5,6,7)
How can i do this by using which stage?
Can u pls guide me?
Thanks and regards
Vijay
how to seperate duplicates and unique records from seq file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The second person personal pronoun in English is spelled "you" - not "u". U is the name of one of our posters.
Please strive for a professional standard of written English on DSXchange - it makes life easier for those whose first language is not English (like U, for example, who is Burmese nationality working in Singapore).
Please strive for a professional standard of written English on DSXchange - it makes life easier for those whose first language is not English (like U, for example, who is Burmese nationality working in Singapore).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I would use a fork-join design with an Aggregator stage performing a count. Downstream of the Join stage a Filter, Switch or Transformer stage can direct rows with a count of 1 to one stream and other rows to the other stream.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.