jointable - join two starbase data tables on matching key columns.
jointable [-a#n] [-v#n] [-j column] [-1 column -2 column] table1 table2
jointable joins two sorted starbase data tables on a key column in each table. Two rows are joined when thier key column value is equil. The tables must be sorted in the same order.
When two or more tables are joined together there is the possibility that the column header names for two column will clash. In this case the column names are appended with "_n" where n is the table number for the column source.
Here is an example with jointable. The two input files each have a column named X and a column named Y. The join column also apears in each table but it is only output once so renaming is not necessary. The X and Y columns are renamed to X_1, Y_1 and X_2, Y_2.
john@panic: jointable -j Name objs.tab coords.tab Name X_1 Y_1 X_2 Y_2 ---- --- --- --- --- ...
Join two tables with object name columns. The tables must be sorted first.
john@panic: sorttable Object < catalog.tab > tmp john@panic: mv tmp catalog.tab john@panic: sorttable Object < object.tab > tmp john@panic: mv tmp object.tab john@panic: jointable -j Object catalog.tab object.tab > joined.tab
Join the same two tables on Object name from the catalog table and Alias from the object table.
john@panic: sorttable Alias < object.tab > tmp john@panic: mv tmp object.tab john@panic: jointable -j1 Object -j2 Alais catalog.tab object.tab > joined.tab
Care must to taken when printing the unpairable line. The column
names can become misaligned when using the -a2 switch.