View previous topic :: View next topic
|
Author |
Message |
rohanthengal
Active User
Joined: 19 Mar 2009 Posts: 206 Location: Globe, India
|
|
|
|
Can i compare 3 files with this ? if yes, then how ? or any alternativfe way.. to do the task |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Only a topic over 6 years old! Ever heard of starting a new topic and not tailgating an old one? |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
If you can be much clearer about what it is that you want, you may get an answer.
A little bit of thought might suggest if not possible/copmplicated with three it would be possible with two.
Take two files and join them together, not excluding/splitting anything. Then take the new file and the third file and do what you actually want to do. So you probably have a "fall-back".
Now, the usual, details of inputputs/outputs. Samples of inputs/outputs. Results of what you have tried so far/don't understand. How it failed. Etc. |
|
Back to top |
|
|
elango_K
New User
Joined: 18 Aug 2011 Posts: 44 Location: India
|
|
|
|
Give some more details about your requirement.
What are the details available in your files.
What do you want to compare?
Can I compare 3 files: Yes
How? : depends on your requirement. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
<dumb> business requirement as posed ...
the output is going to be pretty unmanageable
think about the number of outputs requrred
1 ) record in A not in B not in C
2 ) record in A not in B ... in C
3 ) record in A .. in B not in C
repeat for B and C and eliminate the duplicates
and meditate about the complexity and the futility of the issue
anyway unless I am blatantly wrong here are the otuputs needed
Code: |
record ... in A ... in B ... in C
record ... in A ... in B not in C
record ... in A not in B ... in C
record ... in A not in B not in C
record not in A ... in B ... in C
record not in A ... in B not in C
record not in A not in B ... in C
|
the only case where a 3 diffs is needed is in a clumsy/dumb programming environments
where two independent program changes are to be merged to produce a congruent final program |
|
Back to top |
|
|
rohanthengal
Active User
Joined: 19 Mar 2009 Posts: 206 Location: Globe, India
|
|
|
|
i had 3 files, and having matching/mismatch account numbers.
So i used the ICETOOL SPLICE by matching first and second files in one step, and 2nd & 3rd file in other step, then i compared these two subsets with another splice to produce the common entries. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Good to hear it is working - thank you for letting us know
Your solution is a good way unless you want to design and implement a 3-file match merge. Not as simple as a 2-file match/merge, but has been done many tmes
Depending on the release level of the sort product, you might also look at JOINing the files rather than SPLICEing. |
|
Back to top |
|
|
|