Storing all data in a hash, so this might break down once your files become huge. There is absolutely no error handling in there, so if the file format varies or the entries have spaces in them, it will not work anymore. So please take it as proof of concept and not as production code. 

use strict;
use warnings;

sub readfile {
    my ( $filename, $hashref, $headref ) = @_;
    open my $fh, "<", $filename or die "Cannot open $filename!\n";
    my $headers = <$fh>;
    my @h = split /\s/, $headers;
    $headref->{$_}++ for @h[3..$#h];
    while( <$fh> ) {
        my @line = split /\s/;
        $hashref->{$line[0]}{$line[1]}{$line[2]}{$h[$_]} = $line[$_] f
+or 3..$#h;
    }
    close $fh;
}

my %joined;
my %headers;
for my $file ( qw/file1.txt file2.txt file3.txt/ ) {
    readfile( $file, \%joined, \%headers );
}

print "ID NAME date ", join( " ", sort keys %headers ), "\n";
for my $id ( sort keys %joined ) {
    for my $name ( sort keys %{$joined{$id}} ) {
        for my $date ( sort keys %{$joined{$id}{$name}} ) {
            print "$id $name $date ";
            print join " ", map { $joined{$id}{$name}{$date}{$_} // "-
+-" } sort keys %headers;
            print "\n";
        }
    }
}

[download]

In reply to Re: Merge Columns of Multiple files based on Multiple Common Column by hdb
in thread Merge Columns of Multiple files based on Multiple Common Column by deepak2027

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.