Save and replace table

You can replace an existing table on the 1010data Insights Platform with the results of an analysis. You will then be able to access the results at a later time and share them with others.

To replace an existing table on the 1010data Insights Platform with the results of an analysis:

  1. In a worksheet containing the results of an analysis, click File > Save and Replace Table...

    The Save and Replace 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.

    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 Replace table, select the table you want to replace.
    Note: You can only replace tables that you own ().
  4. Click Replace the Table Selected Below.

The selected table is overwritten.

Note: Be careful! Once you have replaced the selected table, there is no way to get it back.

When you replace 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.