View previous topic :: View next topic
|
Author |
Message |
sreenigacc
New User
Joined: 16 Oct 2007 Posts: 15 Location: bangalore
|
|
|
|
Hi All,
I have a requirement like this.
I have two files and the layout is given below for both the files.
=====================
File 1 layout:
Dealer code X(5)
Amount 9(13).9(2)
================
File 2 layout:
Column1
Column2
.
.
.
Dealer code x(5)
.
.
Amount 9(13).9(2)
=================
When dealer code is similar in both the files, then file1 amount column should be added to File2 amount.
Please let me know, if you need more info on this. Thanks in advance. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
Quote: |
When dealer code is similar in both the files, |
just a new approach to key matching |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Enrico,
maybe it is like levels of i/o |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Maybe it is the second level of testing? First level, you get no matches at all. Fix the obvious. Then it matches a record "nearby" the one it is supposed to, with a similar key. Three days later everything is fine... until the first of 17 bug-reports arrives. |
|
Back to top |
|
|
elango_K
New User
Joined: 18 Aug 2011 Posts: 44 Location: India
|
|
|
|
What level of DFSORT is present in your site?
It can be done by using JOINKEYS. Have a look at the samples and give it a try. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
Please let me know, if you need more info on this. Thanks in advance. |
Yes, we do. Your description is not clear. Show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example. |
|
Back to top |
|
|
|