Append results to an existing table

After you have completed an analysis, you may save the results by appending them to an existing table.

To append the results of an analysis to an existing table:

  1. In an open table or worksheet, click File > Append an Existing Table...

    The Save and Append Table dialog is presented.

  2. Select Save the current actions in the table's description if you would like to save the Macro Language query for the current worksheet in the description for the table.
    Note: Be sure you want to overwrite the existing table's description with the Macro Language query for the current worksheet.

    The table's description can be seen by clicking Help > About this Table or by clicking view info for that table in the Folders and Tables browser.

  3. Under Append table, select the table you want to append your results to.
    Note: You can only append to tables that you own ().
  4. Click Append the Table Selected Below.

    You will be presented with a dialog confirming that you want to append the table.

  5. Click OK.

The results of your analysis are appended to the selected table.

Note: Be careful! Once you have appended your results to the selected table, there is no way to undo it.

An append will add every row in the current worksheet to the selected table only for columns that exist in the selected table. If the selected table contains columns that do not appear in your worksheet, those columns will contain N/A's for each new row. If your worksheet contains columns that do not appear in the selected table, those columns will not be included..

When you append a table with the results of an analysis, only the results are saved, not the actions to the original table that led to the results. If the original table were to change, the new table would not reflect those changes. It is oftentimes better to save the actions of a worksheet as a Quick Query instead. Then, when you view the Quick Query, the actions will be applied to the original table, and the results will be displayed. Not only does this save on space (which is extremely beneficial when you're dealing with large tables), but if the original table has been changed (updated, corrected, etc.), the results will reflect the changes.