Tutorial transcript 4Welcome to the TableBuilder Tutorial Series - Module 4 - Large Tables. In this Module, I'll show you how to create a large table and also work in Large Table Mode.
Once you've logged into TableBuilder and chosen a database you'll be at the Table View screen. From this screen we'll produce a large table. If you build a table of more than 5,000 cells in TableBuilder, you automatically trigger Large Table Mode. This means your table will be sent to a queue for processing. You can retrieve your table once processing has completed.
We will now start by creating a large table. Remember, tables over 5,000 cells will trigger Large Table Mode. We are going to start to create a large table by selecting all the Statistical Local Areas in Australia. We perform the selection by selecting the right pointing toggle of Geographical Areas (Place of Usual Residence), selecting the right pointing toggle after the Main ASGC (9) to expand the drop down menu of “Select all at level”. Then choose SLA level from the drop down menu.
We will add these to the row by selecting the “Add to Row” button above the variables or geographies tree panel. Take note of the cell count on top of the table, we currently have 1,436 cells in our table (i.e. 1 column x 1436 rows). We are still in small table mode.
We are now going to add a variable to trigger Large Table Mode. Under the Person Variables toggle is the People Characteristics toggle. Select the right pointing toggle of People Characteristics to display age and sex variables. Now navigate to the toggle after the AGEP Age (5 Year Groups) ) item and select age groups in five yearly intervals “AGEP – 5 Year Age Groups” from the drop down menu. Add those to the column by selecting the “Add to Column” button.
We now receive a message on a dialogue box, telling us that we are about to enter Large Table Mode. Simply select 'OK' button to continue. The dialogue box now disappeared.
The Table View is now refreshed with a message is displayed on top of the table, telling us that we are now in Large Table Mode. Our table is currently consists of 31,592 cells.
While in Large Table Mode, you can still customise your table. We can 'drag and drop' variables or geography into the recycling bin. We can add or remove geographical areas individually using the drop down in the selection trees inside the variable selection panel.
If you are happy with the structure of your table, simply queue your job by selecting the 'Queue Job' button at the top right corner. In the “Submit Table” dialogue box, we now need to give our table a name (e.g. large table) and select the “Queue Job” button. The dialogue box now disappeared. You will receive a message on screen telling you that your table has been successfully queued to the job queue.
By selecting the 'My Tables' link in-line with the message; you can check the progress of your table in “My Tables” view. As displayed, the status of our large table is “running”. Once the job has been processed, you'll notice the status changes to 'Completed, click here to download'. If you wish to download your table, simply select the appropriate link. Once you selected the “Completed, click here to download” link, the “File Download” dialogue box allows you to 'open' or 'save' your table.
Our large table has been produced in Excel. To open it, select the file to open it. The file is opened in Excel by default. Here is our large table.
Once you've download or saved your table and returned to the My Tables View screen, an expiry time has been entered into the queued jobs box. Tables will automatically be removed from the job queue 10 days after they have been downloaded.
If you wish to save this table for later use, simply select the “Customise Table” link which returns you to the Customise Table view. Select the floppy disk button will display the “Save Table” dialogue box. Give the table a name (Large Table) and select “Save Table” button to save the table. Your table will now appear by selecting the “My Tables” button.
That ends this Module - Large Tables.