You are here: Commands > Table History

Table History

Menu: Found in the TOOLS menu

When run from the menu, the Display History command is issued. For more information and command mode syntax, see Display.

The table history displays:

• The date, time and how a table was created
• The table used
• The commands used, including any refreshable Import command used to create the table.
• Input and output record counts
• Input and output control totals (if you have specified a control total field)

For a table to have a history, it must have been created by an Analyzer command.

To set the maximum number of history entries, use the Set History command. For more information, see Set History.

Examples

In the first example, if Table A (the original table) was sorted to Table B, which in turn was extracted to Table C, which was summarized to Table D, then the Table History of Table D would show:

• Any notes relating to Table A
• Table A as the source table, the date and time of the Sort to Table B, the command mode syntax associated with the Sort command and input and output record count and control totals
• The date and time of the extraction to Table C, Table B as the source table, the command mode syntax associated with the Extract command and input and output record count and control totals
• The date and the time of the stratification to Table D, Table C as the source table, the command mode syntax associated with the Stratify command and input and output record count and control totals

The history of the table is displayed in the Command Log. It is also recorded in the Command Log as commands are issued to create the table. If no history appears in the Command Log, the table has no history.

In the second example, to display the table history for the currently open “Negative Values” table created in the preceding example, in the Command Log text box type:

DISPLAY HISTORY

The table history shows the date and time the file Negative_Values was created and that it was created by extracting all records from the Inventory table that had a negative value or quantity on hand.

Command Mode Syntax

See Display.