Table Editor

There are 5 display areas on the Table Editor

(1)
FILES:
List of, which
contain tables

(2)
INPUT TABLE:
Display
selected file

(3)
COLUMN: INPUT
selected from
the Input Table

(4)
COLUMN: OUTPUT
made from
input column

(5)
OUTPUT TABLE
which uses
the new column

Typical usage

Click on filename in (1).... contents of file will display in (2).
If no files are are listed in (1), see Creating Columns from Scratch below.
Use the Get Column boxes to specify a column to grab from (2). Column will be displayed in (3)
Use one of the many processes, found on the menus above the panels, to modify the column in (3).
The resulting new column will appear in (4).
Decide what to do with the new column.
- Keep it, as is, transferring it to (5).
- Process it further, moving data between (3) and (4).
- Insert it in the original table, (shown in (2)),
  either replacing an original column, or in-between existing columns.
  The result will be displayed in (5).
- Insert the column in a new table, by placing a new table in (2) before doing the Insert.
To keep the new table shown in (5), in a file, give it a filename.

Creating Columns from Scratch

You can also create a column directly.
To do this, use one of the options on the Create menus above the panels.
The newly created column will be displayed in (3).

Extracting Columns

Some files contain several columns. You may want to extract them so that each is in a separate file. Here is a procedure to accomplish this task.

The file with several columns should be located on the Workspace.
Click on the Table Editor button to enter the Table Editor. You should see your file listed in (1), FILES. When you click on it to select it, it will be displayed in (2), INPUT TABLE.
Under Get Column? enter the number of the column you would like to extract, e.g., 1, 2 or 3. When you click on OK, that column will be displayed in (3), INPUT.
Now click on Copy to OUT, and the column will be displayed again in the OUTPUT Column (4). Then, under Keep Output Column?, click on Keep by itself, then on OK. We immediately see this column displayed in (5), OUTPUT TABLE.
The final step is to give the output file a name at Enter Name under Save Table? and click on All. The newly made table is saved to the Workspace, and also appears in 1.
You can go back to the INPUT TABLE (2) and quickly repeat the process for the other columns of your original table, saving each to a separate name.

Last updated: 23 August 2010 (AE)