Recent Pages

Commands at a glance
edittable: trivial tabl ...
indextable: generate ta ...
NoSQL Utilities
Text Formatting Rules
Site SandBox
Change Management
Wiki Editor's How-To
Site Terms of Use
Site Copyright

Links

NoSQL Home

Table of Contents

Wiki Editor's How-To

Text Formatting Rules

Wiki SandBox

www.strozzi.it on Twitter

Google Ads

Please Support NoSQL !

Session

User ID
Password

Campaigns

Concatenating tables

The need to concatenate tables comes up every so often, and, although it is simple to do the method may not be obvious. The UNIX 'cat' command cannot be used as it would result in duplicating the header and thus cause an invalid output table. And, of course, only tables with the same header, i.e. tables that are said to be ``union-compatible,'' should be concatenated, otherwise an invalid table would result. If we have two tables, TABA and TABB, then to concatenate TABB onto the end of TABA we use the command:

       tablecat TABA TABB