UNIX for Dummies Questions & Answers

Bob, Green, 80
Mark, Brown, 70
Tina, Smith, 60

Bob, Green, 70
Mark, Brown, 60
Tina, Smith, 50

Bob, Green, 50
Mark, Brown,60
Tina, Smith, 70

Bob, Green, 60
Mark, Brown, 70
Tina, Smith, 80

Bob, Green, 80, 70, 50, 60
Mark, Brown, 70, 60, 60, 70
Tina, Smith, 60, 50, 70, 80

join -1 1 -2 1 -o 1.1 1.2 1.3 2.3 file1.csv file2.csv > combine.csv

awk -F, '
        {
                A[$1 FS $2] = A[$1 FS $2] ? A[$1 FS $2] FS $NF : $NF
        }
        END {
                for ( k in A )
                        print k FS A[k]
        }
' file[1-4]

 print A[k]

FILES="output/*"
for W in $FILES
do
	doc=$(basename $W)
	awk -F, '{A[$1 FS $2] = A[$1 FS $2] ? A[$1 FS $2] FS $NF : $N} END {for ( k in A ) print A[k]}'  $W > output-4.csv 
done

awk -F, '{A[$1 FS $2] = A[$1 FS $2] ? A[$1 FS $2] FS $NF : $N} END {for ( k in A ) print A[k]}' output/* > output-4.csv