STILTS-TJOIN(1) | Stilts commands | STILTS-TJOIN(1) |
NAME¶
stilts-tjoin - Joins multiple tables side-to-sideSYNOPSIS¶
stilts tjoin [nin=<count>] [ifmtN=<in-format>] [inN=<tableN>] [icmdN=<cmds>] [ocmd=<cmds>] [omode=out|meta|stats|count|cgi|discard|topcat|samp|tosql|gui] [out=<out-table>] [ofmt=<out-format>] [fixcols=none|dups|all] [suffixN=<label>]
DESCRIPTION¶
tjoin performs a trivial side-by-side join of multiple tables. The N'th row of the output table consists of the N'th row of the first input table, followed by the N'th row of the second input table, ... and so on. It is suitable if you want to amalgamate two or more tables whose row orderings correspond exactly to each other.For the (more usual) case in which the rows of the tables to be joined are not already in the right order, use one of the crossmatching commands.
OPTIONS¶
- nin=<count>
- ifmtN=<in-format>
- inN=<tableN>
- A filename.
- A URL.
- The special value "-", meaning standard input. In this case the input format must be given explicitly using the ifmtN parameter. Note that not all formats can be streamed in this way.
- A system command line with either a "<" character at the start, or a "|" character at the end ("<syscmd" or "syscmd|"). This executes the given pipeline and reads from its standard output. This will probably only work on unix-like systems.
- icmdN=<cmds>
Commands may alteratively be supplied in an external file, by using the indirection character '@'. Thus a value of "@filename" causes the file filename to be read for a list of filter commands to execute. The commands in the file may be separated by newline characters and/or semicolons, and lines which are blank or which start with a '#' character are ignored.
- ocmd=<cmds>
Commands may alteratively be supplied in an external file, by using the indirection character '@'. Thus a value of "@filename" causes the file filename to be read for a list of filter commands to execute. The commands in the file may be separated by newline characters and/or semicolons, and lines which are blank or which start with a '#' character are ignored.
- omode=out|meta|stats|count|cgi|discard|topcat|samp|tosql|gui
Possible values are
- out
- meta
- stats
- count
- cgi
- discard
- topcat
- samp
- tosql
- gui
- out=<out-table>
This parameter must only be given if omode has its default value of "out".
- ofmt=<out-format>
This parameter must only be given if omode has its default value of "out".
- fixcols=none|dups|all
- none: columns are not renamed
- dups: columns which would otherwise have duplicate names in the output will be renamed to indicate which table they came from
- all: all columns will be renamed to indicate which table they came from
- suffixN=<label>
SEE ALSO¶
stilts(1)If the package stilts-doc is installed, the full documentation
SUN/256 is available in HTML format:
file:///usr/share/doc/stilts-doc/sun256/index.html
VERSION¶
STILTS version 3.1-5-debianThis is the Debian version of Stilts, which lack the support of
some file formats and network protocols. For differences see
file:///usr/share/doc/stilts/README.Debian
AUTHOR¶
Mark Taylor (Bristol University)Mar 2017 |