Compare records with same key
Posted: Tue Sep 12, 2017 10:54 pm
Hi,
I need an output file with only one registry per key with two values
pos 2: 1 - When the input register contains the values 101 or 103 or 104
pos 3: 1 - When the input register contains the values 109 or 108
Input File
A107
A108
A109
B103
B104
C109
Output file
A11
B10
C01
Can you help me?
Thanks
I need an output file with only one registry per key with two values
pos 2: 1 - When the input register contains the values 101 or 103 or 104
pos 3: 1 - When the input register contains the values 109 or 108
Input File
A107
A108
A109
B103
B104
C109
Output file
A11
B10
C01
Can you help me?
Thanks