Merge records of the input file using SORT
Posted: Mon May 26, 2008 8:57 pm
Good morning,
The next example is similar at the topic f=28&t=596 but i don't get the output correctly...
I need join of two files...
input 1 (25 position)
input 2 (16 position)
And I need obtain an outful file with 34 position with the keys is the first 7 position (the key for first file has duplicates; the second file no duplicates).
output (25+9=34 position)
The next example is similar at the topic f=28&t=596 but i don't get the output correctly...
I need join of two files...
input 1 (25 position)
uuuuuuuoooooooooooooooooo
uuuuuuupppppppppppppppppp
vvvvvvvrrrrrrrrrrrrrrrrrr
vvvvvvvyyyyyyyyyyyyyyyyyy
xxxxxxxaaaaaaaaaaaaaaaaaa
xxxxxxxbbbbbbbbbbbbbbbbbb
xxxxxxxcccccccccccccccccc
xxxxxxxzzzzzzzzzzzzzzzzzz
xxxxxxxyyyyyyyyyyyyyyyyyy
yyyyyyyeeeeeeeeeeeeeeeeee
yyyyyyyffffffffffffffffff
zzzzzzziiiiiiiiiiiiiiiiii
zzzzzzziiiiiiiiiiiiiiiiii
uuuuuuupppppppppppppppppp
vvvvvvvrrrrrrrrrrrrrrrrrr
vvvvvvvyyyyyyyyyyyyyyyyyy
xxxxxxxaaaaaaaaaaaaaaaaaa
xxxxxxxbbbbbbbbbbbbbbbbbb
xxxxxxxcccccccccccccccccc
xxxxxxxzzzzzzzzzzzzzzzzzz
xxxxxxxyyyyyyyyyyyyyyyyyy
yyyyyyyeeeeeeeeeeeeeeeeee
yyyyyyyffffffffffffffffff
zzzzzzziiiiiiiiiiiiiiiiii
zzzzzzziiiiiiiiiiiiiiiiii
input 2 (16 position)
uuuuuuuRRRRRRRRR
xxxxxxxYYYYYYYYY
yyyyyyyPPPPPPPPP
ZZZZZZZddddddddd
xxxxxxxYYYYYYYYY
yyyyyyyPPPPPPPPP
ZZZZZZZddddddddd
And I need obtain an outful file with 34 position with the keys is the first 7 position (the key for first file has duplicates; the second file no duplicates).
output (25+9=34 position)
uuuuuuuoooooooooooooooooo (input 1) RRRRRRRRR (input 2)
uuuuuuupppppppppppppppppp (input 1) RRRRRRRRR (input 2)
vvvvvvvrrrrrrrrrrrrrrrrrr (input 1) 9 blanks because not coincidence
vvvvvvvyyyyyyyyyyyyyyyyyy (input 1) 9 blanks because not coincidence
xxxxxxxaaaaaaaaaaaaaaaaaa (input 1) YYYYYYYYY (input 2)
xxxxxxxbbbbbbbbbbbbbbbbbb (input 1) YYYYYYYYY (input 2)
xxxxxxxcccccccccccccccccc (input 1) YYYYYYYYY (input 2)
xxxxxxxzzzzzzzzzzzzzzzzzz (input 1) YYYYYYYYY (input 2)
xxxxxxxyyyyyyyyyyyyyyyyyy (input 1) YYYYYYYYY (input 2)
yyyyyyyeeeeeeeeeeeeeeeeee (input 1) PPPPPPPPP (input 2)
yyyyyyyffffffffffffffffff (input 1) PPPPPPPPP (input 2)
zzzzzzziiiiiiiiiiiiiiiiii (input 1) ddddddddd (input 2)
zzzzzzziiiiiiiiiiiiiiiiii (input 1) ddddddddd (input 2)
uuuuuuupppppppppppppppppp (input 1) RRRRRRRRR (input 2)
vvvvvvvrrrrrrrrrrrrrrrrrr (input 1) 9 blanks because not coincidence
vvvvvvvyyyyyyyyyyyyyyyyyy (input 1) 9 blanks because not coincidence
xxxxxxxaaaaaaaaaaaaaaaaaa (input 1) YYYYYYYYY (input 2)
xxxxxxxbbbbbbbbbbbbbbbbbb (input 1) YYYYYYYYY (input 2)
xxxxxxxcccccccccccccccccc (input 1) YYYYYYYYY (input 2)
xxxxxxxzzzzzzzzzzzzzzzzzz (input 1) YYYYYYYYY (input 2)
xxxxxxxyyyyyyyyyyyyyyyyyy (input 1) YYYYYYYYY (input 2)
yyyyyyyeeeeeeeeeeeeeeeeee (input 1) PPPPPPPPP (input 2)
yyyyyyyffffffffffffffffff (input 1) PPPPPPPPP (input 2)
zzzzzzziiiiiiiiiiiiiiiiii (input 1) ddddddddd (input 2)
zzzzzzziiiiiiiiiiiiiiiiii (input 1) ddddddddd (input 2)