SuperSTAR : Save and Reload Tables - SuperWEB2

You can save your tables inside SuperWEB2. Once saved, the table definitions will be available again the next time you log in to SuperWEB2.

Tables saved by users in SuperWEB2 are typically private (only visible and accessible to the user who created the table). Depending on how your administrator has configured SuperWEB2, you may also be able to load and save shared tables, which are accessible to multiple SuperWEB2 users.

If you are logged in as a guest user, you will not be able to save tables.

Save Tables

Click the Save icon to save the current table:

The mouse pointer hovering over the Save Table icon in Table View

You will be prompted to select the save location and enter a name for the table. Choose your name and location and click Save:

The Save Table dialog, with the name Marital Status by Gender entered in the Name field and the mouse pointer hovering over the Save button

Depending on how your system administrator has configured SuperWEB2, you may have a choice of save locations:

  • Choose the Private folder to save a table that is accessible to you only (this option is always available to logged in users).
  • Choose any of the shared folders (indicated by the shared folder symbol, The Shared Folder icon) to save a table that will be accessible to other SuperWEB2 users. You will only be able to save to a shared folder if your administrator has given you permissions to save to that folder. The folder permissions will also determine which other SuperWEB2 users will be able to access the folder. Check with your administrator to confirm how permissions have been set up in your SuperWEB2 deployment.

The name of the table must be less than 255 characters long. When you save tables to the Private folder, they must have a unique name; tables saved to a shared folder can have the same name as an existing saved shared table.

Your administrator may have configured a limit on the maximum number of private saved tables you can have at any one time. If you have exceeded this limit you will not be able to save any more private tables until you go to Manage Tables and delete some of your existing saved private tables.

Please note that this limit does not apply to shared tables.

Load Tables

You can reload saved tables one of three ways: from Table View, from Manage Tables and from Datasets.

Table View

You can access saved tables direct from Table View. Click the Tables tab:

The mouse pointer hovering over the Tables tab above the field list

SuperWEB2 displays a list of all the saved tables you have access to for this dataset. Double-click a table to open it, or click once to select and click Open Table.

The Tables tab in Table View and the mouse pointer hovering over a saved table

Manage Tables

Select the Manage Tables option from the menu in the top right of SuperWEB2:

The Manage Tables option on the SuperWEB2 menu

  1. Select Manage Tables.
  2. Select the table you want to reopen.
  3. Click Open.
    The Saved Tables list on the Manage Table screen, with the mouse pointer hovering over the Open button
    If you currently have a table open, then SuperWEB2 displays a message warning you that any unsaved table content will be lost (this means that the selected table will replace the currently active table). Click OK.
  4. Your saved table displays.

Datasets

You can also access saved tables from the Datasets tab. This is displayed when you log in to SuperWEB2, or whenever you click the Datasets link in the top left corner:

The mouse pointer hovering over the Datasets tab

To open your saved table, click the dataset it was created from, then go to the Tables list and double-click the table name. For example:

The data catalogue screen with a dataset selected and the list of saved tables for that dataset shown in the Tables pane

Manage Saved Tables

Manage Tables also allows you to rename saved tables, create new copies of saved tables, and delete saved tables:

Rename and Copy are only available for private saved tables.

Rename a Saved Table

This option is available for private saved tables only:

  1. Select the check box next to the table you want to rename.
  2. Enter a new name in the text box.
  3. Click Rename.

Copy a Saved Table

This option is available for private saved tables only:

  1. Select the check box next to the table you want to copy.
  2. Click Copy.

Delete a Saved Table

  1. Select the check box next to the table or tables you want to delete.
  2. Click Delete.
  3. Click OK to confirm you want to delete the table or tables. Make sure you check that you are deleting the correct table or tables, as there is no way to undo the deletion.

Your administrator may have configured a limit on the number of saved tables you can have at any one time. You should delete any unused tables so you have enough space to continue saving your customised tables.

Change the Table Sort Order

Depending on how your administrator has configured SuperWEB2, you may be able to change the order that tables are listed in the Saved Tables tab.

To check and change this setting:

  1. Click the menu button in the top-right corner and select Account:

    The Account option in the SuperWEB2 menu

  2. Choose between Alphabetical (tables will be displayed in ascending alphabetical order) or Last Modified (the most recently modified/created tables will appear at the top of the list). 

    Saved Tables Sort Order with the options Alphabetical and Last Modified and the mouse pointer hovering over the Save button

  3. Click Save.

If you do not see this option, then this means that your administrator has turned off the ability to set this preference. Your saved tables will be displayed in the order set by your administrator (by default, this is alphabetical order).

Large Table Downloads

If your system has been configured to use the Job Queue Manager feature, then the Manage Tables tab may also show details of large tables that you have queued for download. You can use the options to check the status of large table queries, download any tables that have completed processing, and manually delete the tables:

The Queued Jobs view showing the table Age by Postal Code is ready for download

See Large Tables for more information about using SuperWEB2 in large table mode.