I need to merge (or is it join?) two data sets by the id field for both data. These are fictional data sets for example.

Data set 1:
id x1 x2
A 12 45
A 10 12
A 15 74
C 11 41
C 18 12
B 23 15
D 19 10
D 11 12
E 14 5
E 34 31
F 10 45

Data set 2:
id word
A hello
B goodbye
D happy
E black
C blue

I want to keep all the data is Data 1, as long as it matches with Data 2, by id.

Desired output
A 12 45 hello
A 10 12 hello
A 15 74 hello
C 11 41 blue
C 18 12 blue
B 23 15 goodbye
D 19 10 happy
D 11 12 happy
E 14 5 black
E 34 31 black

Here is the code I am using so far: 
 
my %file1hash;

open (DAT1,"$fin1");

while(my $line=<DAT1>) {
    chomp($line);
    my ($id,$x1,$x2)=split(' ' ,$line);
    $file1hash{$id} = "$x1 $x2";
}

close DAT1;

open (DAT2,"$fin2");
while (my $line=<DAT2>) {
    chomp($line);
    my ($id,$word)=split(' ', $line);
        if (exists $file1hash{$id}) {
        printf ("%1s %5s %7s\n", $id, $file1hash{$id}, $word);     
    }
}
close DAT2;

exit;

[download]

My output from this code is
A 15 74 hello
B 23 15 goodbye
D 11 12 happy
E 34 31 black
C 18 12 blue

Almost there, but it only takes the last values for each id. Any help or direction to a previously asked similar question would be appreciated. Thanks!

In reply to Merging two data sets by sonicbill11

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.