logjoin

logjoin is a tool for joining two log files (or any kind of CSV output) on a common column and concatenates the result, thus simulating MySQL join command between two files. With the help of parsers like awk it can give useful reports.

Examples:

* Joining two log files by their 4th and 3rd column giving result in result.txt
logjoin -v -o result.txt -j 4=3 leftlog.txt rightlog.txt

* Inner-join of two log files on their first columns
logjoin -i leftlog.txt rightlog.txt > result.txt

* Inner-join of leftlog.txt and rightlog.txt on 2nd and 3rd column and join with thirdlog on 1st and 2nd
cat leftlog.txt | logjoin -i -j 2=3 rightlog.txt | logjoin -j 1=2 thirdlog.txt

It depends on command-line parser library at http://tclap.sourceforge.net/