|
View previous topic :: View next topic
|
| Author |
Message |
subbuy2k
New User
Joined: 17 Apr 2009
Posts: 8
Location: milford
|
|
|
|
Hi,
I have records coming from 3 different states(NY,NJ,CT). If the customer # is part of all three states then in output file i have to write only the NY record. If not i have to write the other two states.Can we do this in syncsort. I dont want to do this in cobol pgm or icetool.
example
INPUT
========
1111111 NY
1111111 NJ
1111111 CT
2222222 NJ
2222222 NY
3333333 NJ
3333333 CT
OUTPUT
-----------
1111111 NY
2222222 NJ
2222222 NY
3333333 NJ
3333333 CT
__________________
Thanks |
|
| Back to top |
|
 |
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Your description does not match with your example, as far as I understand. Your description says:
| Quote: |
| If the customer # is part of all three states then in output file i have to write only the NY record. |
then for this input
| Quote: |
2222222 NJ
2222222 NY |
why do you have this
| Quote: |
2222222 NJ
2222222 NY |
as output, it should have been
? |
|
| Back to top |
|
|
subbuy2k
New User
Joined: 17 Apr 2009
Posts: 8
Location: milford
|
|
|
|
| 2222222 is not part of 3 states. Its part of NY and NJ not part of CT. So we need both. |
|
| Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
subbuy2K,
Please do not post the same question in multiple forums. This question has already been addressed in the other forum. Therefore, I am locking this thread. If you have any further questions regarding this issue, please post where the solution was provided. Thank you. |
|
| Back to top |
|
|
|
|
