Posted: Thu Jan 20, 2011 11:15 am Post subject: Concatenation of fields in different files
Can any one help me...pls...
I've three files with 2 fields item no and name, in another file item no and cost, and in the last file item no and quantity. Now I want to form a file with a new record structure of item no,cost and quantity. All item nos are unique in each file. _________________ Thanks&Regards
Last edited by nareshmdk on Mon Jan 24, 2011 1:05 pm; edited 1 time in total
Joined: 09 Aug 2008 Posts: 1631 Location: Mumbai, India
Posted: Thu Jan 20, 2011 4:15 pm Post subject:
Your description is not very clear, however, it looks like you want to match/merge three files and write some output, is this what you intend to do - if not, please describe your problem again. _________________ Regards,
Last edited by Anuj Dhawan on Mon Jan 24, 2011 3:16 pm; edited 1 time in total
you don't need name in the output it is a simple 2 file match/merge.
and compare is not the term to use.
you simply want to match & merge (join) the two files.
now, if in your seriously incomplete requirements
you failed to mention that name is also required,
you have a 3 file match merge.
suggest you start by generating some pseudo-code (or flow chart) to define the process. _________________ Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum