Select only paired records
Posted: Mon Jul 14, 2014 4:30 pm
Hi to all,
I'm new to this forum. so excuse me if the query posted is duplicate etc.
I need help in setting up a new sort card to get the result i wanted.
Below is the i/p file record format.
o/p should only have records(ex. 20006/20009) which have both ADMIN & USER entry in a single line and rest others to be dropped and it look like this.
We need to achieve this using sort. so any help/guide would be much appreciated.
thanks
venu
Code'd
I'm new to this forum. so excuse me if the query posted is duplicate etc.
I need help in setting up a new sort card to get the result i wanted.
Below is the i/p file record format.
pos 1:8 pos 9:18 pos 19:33
20006 ADMINLOGUT 111111111111111
20006 USERLOGIUT 222222222222222
20007 USERLOGIUT 555555555555555
20008 USERLOGIUT 777777777777777
20009 ADMINLOGUT 888888888888888
20009 USERLOGIUT 999999999999999
20006 ADMINLOGUT 111111111111111
20006 USERLOGIUT 222222222222222
20007 USERLOGIUT 555555555555555
20008 USERLOGIUT 777777777777777
20009 ADMINLOGUT 888888888888888
20009 USERLOGIUT 999999999999999
o/p should only have records(ex. 20006/20009) which have both ADMIN & USER entry in a single line and rest others to be dropped and it look like this.
pos 1:8 pos 9:18 pos 19:33 pos 34:43 pos 44:58
20006 ADMINLOGUT 111111111111111 USERLOGIUT 222222222222222
20009 ADMINLOGUT 888888888888888 USERLOGIUT 999999999999999
20006 ADMINLOGUT 111111111111111 USERLOGIUT 222222222222222
20009 ADMINLOGUT 888888888888888 USERLOGIUT 999999999999999
We need to achieve this using sort. so any help/guide would be much appreciated.
thanks
venu
Code'd