The Save Table Button

This section will cover:

Introduction
Save Tables
Load Saved Tables
- Manage Tables Table
- Home Tab
Manage Saved Tables
- Rename a Saved Table
- Copy a Saved Table
- Delete a Saved Table
Large Tables Downloads (Advanced)
Knowledge Check

Introduction

The learning objectives for this page are:

Understanding how save your table
How to find and re-edit your saved tables

Save Tables

One of the functions that is not available as a guest user but is for registered users is the ability to save tables in Stat-Xplore. Once saved, the table definitions will be available again the next time you log in to Stat-Xplore. These tables that are saved by users in Stat-Xplore are private which means they are only visible and accessible to you.

To save a currently open table,

Click the 'Save Button' to save the current table:

In Employment filter added

You will then be prompted to select where to save your table (the save location) and enter a name for the table. The name of the table must be less than 255 characters long and must have a unique name. Choose your name and location and click Save:

In Employment filter added

Stat-Xplore is configured to automatically allow users to save their tables to their Private folder. This folder allows you to save tables which are only accessible to you.

Load a Saved Table

Once you have saved a table, there are two methods to accessing your save tables: using the ‘Manage Tables’ tab or using the ‘Home’ Tab. Please read through the two methods and use the one that is the most intuitive and easy for you.

Manage Tables Tab

Once you have saved a table, to access that table and any other saved tables again,

Look at the top right-hand corner of the page, click on the Vertical Ellipsis (three Vertical dots) which will then triggers a drop-down menu where you can then click the option named ‘Manage Tables’.

In Employment filter added

Select which saved table you want to reopen and click once on the ‘Open’ button.

In Employment filter added

If you currently have a table open, then Stat-Xplore 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 if you would still like to save the table.

Your table is now saved and ready to be re-opened at any time!

Load a Saved Table - Home Tab

Additionally, you can also access your saved tables from the ‘Home’ tab by,

Look at the top left-hand corner of the page and click the option called ‘Home’.

In Employment filter added

To open your saved table, click once on the dataset it was created from, then go to the Tables list to the right. For example, in the screenshot below, the saved table named ‘Universal Credit by Gender and Month’ is organised under the Private folder.

In Employment filter added

Double-click the name you saved your table as to open it..

Manage Saved Tables

In addition to accessing your saved tables as mentioned above, the ‘Manage Tables’ table also allows you to rename saved tables, create new copies of saved tables, and delete saved tables. Feel free to browse and read the sections that are relevant to you.

Rename a Saved Table

Look at the top right-hand corner of the page, click on the Vertical Ellipsis (three Vertical dots) which will then triggers a drop-down menu where you can then click the option named ‘Manage Tables’.
Select which saved table you want to rename and select the check box next to the table you want to rename.
Enter a new name in the text box which is located at the bottom left-hand corner of the screen.
After entering the new name of the table, click the button Rename.

Copy a Saved Table

Look at the top right-hand corner of the page, click on the Vertical Ellipsis (three Vertical dots) which will then triggers a drop-down menu where you can then click the option named ‘Manage Tables’.
Select the check box next to the table you want to copy.
Click the button Copy which is located at the bottom left-hand corner of the screen.

Delete a Saved Table

Look at the top right-hand corner of the page, click on the Vertical Ellipsis (three Vertical dots) which will then triggers a drop-down menu where you can then click the option named ‘Manage Tables’.
Select the check box next to the table or tables you want to delete.
Click the Delete button which is located at the bottom left-hand corner of the screen.
Click the OK button to confirm you want to delete the table or tables. Make sure to double-check that you are deleting the correct table or tables as you cannot undo the deletion.

Large Table Downloads (advanced)

Within your ‘Manage Tables’ tab, in addition to your saved tables it also shows details of large tables that you have queued for download. Within this, you can check the status of large table queries, download any tables that have completed processing, and manually delete the tables as seen in the screenshot below.

In Employment filter added

For further information and clarification about using Stat-Xplore in large table mode, see Large Tables.

Further Questions

If you still have any questions that are not answered in the guide, please feel free to email Stat.Xplore@dwp.gov.uk

Check your Knowledge!

Navigate to the dataset ‘Attendance Allowance’ and the data cube ‘AA Cases with Entitlement – Data to February 2018’. Save the pre-existing table called ‘AA Entitlement 1 – Gender (to Feb 2018)’ and rename this as ‘3c. Save Tables Answer’ under your private folder. Then navigate to your saved tables and check that you have done so.

Show/hide Solution Answer Show Answer