Sorry noob here......

I have 2 files like this:

File A
8080000001 400
8080000002 300
8080000003 200


File B
8080000001 600
8080000002 200
8080000004 200


I want one file where

File OUT
8080000001 1000
8080000002 500
8080000003 200
8080000004 200

I appreciate any help with this.

Thanks

Do not post questions without trying to solve the problem yourself based on your understanding.
Please read Simple rules of the UNIX.COM forums: before posting, especially 5 and 6.

start with this:

awk ' FILENAME=="fileb" {arr[$1]+=$2}
        FILENAME=="filea" {arr{$1]+=$2}
        END{for (i in arr {print i, arr[i] } ' filea fileb > filec

What about..

awk '{a[$1]+=$2}END{for(i in a) print i, a[i]}' file1 file2 file3 .... fileX > output_file

awk:

nawk '{
if(NR==FNR)
	arr[$1]=$2
else
	arr[$1]+=$2
}
END{
for(i in arr)
	print i" "arr[i]
}' a b

open(FH,"<a");
while(<FH>){
	$_=~tr/\n//d;
	@arr=split(" ",$_);
	$hash{$arr[0]}=$arr[1];
}
close(FH);
open(FH1,"<b");
while(<FH1>){
	$_=~tr/\n//d;
	@arr=split(" ",$_);
	$hash{$arr[0]}+=$arr[1];
}
close(FH1);
for $key (sort keys %hash){
	print $key," ",$hash{$key},"\n";
}

Hi ,
I have 2 files and want to group by 1st and 2nd column using perl

File A
SGD 8080000001 400
USD 8080000002 300
HK 8080000003 200


File B
SGD 8080000001 600
SGD 8080000002 200
HK 8080000004 200


I want one file where

File OUT
SGD 8080000001 1000
USD 8080000002 300
SGD 8080000002 200
HK 8080000003 200
HK 8080000004 200

awk '{a[$1 FS $2]+=$3}END{for(i in a) print i, a[i]}'  file1 file2 file3 .... fileX> output_file