View previous topic :: View next topic
|
Author |
Message |
adrianlmk
New User
Joined: 02 Jan 2008 Posts: 11 Location: Malaysia
|
|
|
|
Hi,
I'm new to use Group= function and searching around and doesn't find the similar example for my reference.
Byte 1 to 9 is the grouping, whenever found a value of 'R' in Byte 11, 'Y' need to be updated into bytes 10 for the same group
Hopefully can get some help from here
My Input is
Code: |
12345678901 <--- Column
T20140811NO
T20140811NP
T20140811NR
T20140812NO
T20140812NP
T20140813NR
T20140813NO
|
My Output expected is
Code: |
T20140811YO
T20140811YP
T20140811YR
T20140812NO
T20140812NP
T20140813YR
T20140813YO
|
|
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
You're probably better off looking a JOINKEYS, with the same DSN for both input files.
In the JNF2CNTL include just the Rs. Then in the Main Task of the JOIN, set Y for those which match. |
|
Back to top |
|
|
|