The My Custom Data screen allows you to group similar data items or geographic areas into custom groups which you can then add to your table.

Groups can only include items of the same type. For example, you can create a new age group of 13 to 19 years and name it 'Teenagers', or create a new geographic area by grouping the suburbs that make up your local area.

Your groups are saved in your TableBuilder account and you can reuse them in later TableBuilder sessions. You can edit, delete and re-name your groups at any time.

The My Custom Data screen can be accessed from Table View, by clicking the link at the top left under the Table View tab.

Picture showing Table View tab is active and My Custom Data link selected.


The My Custom Data screen allows you to:
  • Create custom data and custom geographic area groups.
  • Use the Map to Group tools to create custom geographic area groups.
  • Copy custom data groups.
  • Edit custom data groups.
  • Delete custom data groups.
  • Rename custom data groups.
  • Export a custom group.
  • Edit a custom group outside TableBuilder.
  • Import a custom group into TableBuilder.

6.1 Create custom data and custom geographic area groups

The My Custom Data and Geography box appears on the top left of the screen. It displays custom groups saved in previous sessions. The tools to create new groups begin at Step 1 in the box below.

To create a new custom data group:
  1. At Step 1 the tree control shows all the geographical areas and data variables or 'characteristics' available for the chosen database.
  2. Click the expand button Picture showing an expand button (that is a button with a plus sign on it) to expand the tree structure to show the data items or geographic areas that you wish to group.

    Picture showing data item INGP Indigenous Status expanded into 5 options, with 3 options marked with a tick.

  3. To select items, tick only the required items within the same classification or geographic level, or use the Select All arrow.
  4. Click on the Add to Current Group Items button Picture showing a button with 3 right pointing arrows on it. ; your selections will appear in the Current Group Items box:

    Picture showing an edit box and a Save Group button on its right. Below is a list of Current Group Items with options to tick all, untick all or tick individual option.

    Note: Once you have added an item to the Current Group Items box, you can remove it at any time before saving your custom group:
    • Select the item by clicking in the tick box beside it;
    • Click on the Remove from Current Group Items button Picture showing a button with 3 left pointing arrows. to remove it.
  5. Type the name of your new custom group in the text box at Step 2

    Picture showing edit box filled with Indigenous Persons and Save Group button on its right.
  6. Click on the Save Group button.
  7. Your new custom group will now appear in the My Custom Data and Geography box in the tree structure under the original geography or classification it was created from.

    Picture showing options under My Custom Data and Geographpy in tree structure.

The custom group can now be added to your table using the same method as adding a standard item, as shown in Chapter 4.2.

TIP: A custom group name needs to be individual. For example if you are creating the same custom group (persons aged 15 years and over) for both 2006 and 2011, call your custom groups '2006 Aged 15 years and over' and '2011 Aged 15 years and over'.

If a custom group or geographic area has already been created with the same name for another Census year, then you will get the error message: 'Group not saved, name already exists, please choose another name'.

6.2 Use the Map to Group tools to create custom geographic areas

Map to Group Items enables you to use an interactive map to navigate to and select areas to include in your custom geographic area.

On the Table View tab, click on the My Custom Data link. Map to Group is accessed by clicking on the link called ‘Use Map to Group Items’ link.

Picture showing Table View tab and My Custom Data link selected. Option "Use Map to Group Items" is highlighted in red hollow rectangle.


To create a custom geographic areas group:
  1. In the drop down list above the map, select the geographic level of the areas you wish to group.

    Picture showing Table View tab and My Custom Data link selected. Map layer combo box states Select Grographical Level.
  2. Use the map tools to select the specific areas on the map to include in your custom geography group (see Map tools below). A maximum of 2000 areas can be selected.
  3. Click on the Picture showing a button with 3 right pointing arrows button. Your selections will appear in the Current Group Items box.

    Note: The areas selected on the map will not automatically clear once you have moved them to the Current Group Items.

    TIP: To remove an item from the Current Group Items list select the item by clicking in the tick box beside the item then click on the Remove from Custom Group Items button Picture showing a button with 3 left pointing arrows to remove it.
  4. Enter a name for your group in the text box at Step 2.
  5. Click on the Save Group button Picture of a button with words "Save Group" on it.. Your new custom group will appear in the My Custom Data and Geography box in the tree structure under the original geographic level it was created from.

Picture showing a map on the left "Map layer 2011 Statistical Area Level 1, with a group of areas within a circular radius highlighted in blue ", and a list of codes for select on the right.

Map tools
Use the following tools to group geographic areas into a customised region.

Picture showing an arrow pointing at a hollow rectangel Select Area
The Select Area tool is used to select multiple areas. It can be used to select geographic areas by clicking on them, or by clicking and dragging a rectangle around the areas to be selected.

Picture showing a red back slash over an arrow pointing at a rectangle Deselect Area
The Deselect Area tool is used to de-select an individual geographic area by clicking on it, or multiple areas by clicking and dragging a rectangle around the areas to be deselected.

Picture showing a magnifying glass with a plus sign on it Zoom In
The Zoom In tool is used to get a closer view of the map. Single clicking magnifies the map by a set scale factor. The map view will then be centred at the location at which the mouse was clicked. Alternatively, performing a click and drag function on the map allows you to display a map that best fits the rectangle that was selected. See also Zoom Bar.

Picture showing a magnifying glass with a minus sign on it Zoom Out
The Zoom Out tool is used to view a wider area of the map. The single click method allows you to see a new map view, which has been zoomed out by a set scale factor. The map view will then be centred at the location at which the mouse was clicked.

Picture showing an arrow pointing at northerly west direction. Select Area Pointer
The Select Area pointer is used to select a single geographical area. By performing a single click, you are able to highlight a specific area on the map. Any other areas already highlighted will be deselected.

6.3 Copy custom data groups

  1. Locate the custom data group you want to copy in the My Custom Data and Geography box by expanding the classification tree.
  2. Click in the tick box next to the custom data group to select it.

    Picture showing my customer data option of Custom Geography is selected, at the bottom are the option to edit, copy, delete, download, rename or upload data.
  3. Click the Copy buttonPicture of a button with the word 'Copy' on it. . A duplicate group item will appear with the name followed by “Copy 1”.

6.4 Edit custom data groups

  1. In the My Custom Data and Geography box expand the tree structure to locate the custom group you wish to edit.
  2. Select it by clicking in the tick box beside it.
  3. Click on the Edit button Picture of a button with the word 'Edit' on it. . The current content of the group will be listed in the Step 2: Current Group Items box.
  4. Add or remove items using the Add to Current Group Items Picture of a button with 3 right pointing arrows on it. and Remove from Current Group Items Picture of a button with 3 left pointing arrows on it. buttons.
  5. Click on the Save Group buttonPicture showing a button with the words "Save Group" on it..
TIP: You can cancel editing without saving by clicking on the Cancel Edit button .

6.5 Delete custom data groups

  1. In the My Custom Data and Geography box expand the tree structure to locate the custom group you wish to delete.
  2. Select the group by clicking in the tick box beside it.
  3. Click the Delete buttonPicture showing a button with the word "Delete" on it. . You cannot undo this action.

6.6 Rename custom data groups

  1. In the My Custom Data and Geography box expand the tree structure to locate the custom group you wish to rename.
  2. Select the group by clicking in the tick box beside it.
  3. Type the new name in the Rename text box. This will enable the Go button Picture of button with the word 'Go' on it..

    Picture of an edit box labelled Rename and a button with the word 'Go' on it. Both the box and the Go button are inactive.
  4. Click the Go button. The screen will refresh and the custom group will be renamed.

6.7 Export a custom data group

To download (or export from TableBuilder) a custom data group:
  1. Click on the custom group you wish to save in the My Custom Data and Geography box.
  2. Click the Download button below the box.
  3. A pop up box will ask you if you want to save or open the file.
  4. Click on 'Save the file'.
  5. Select the location in which you wish to save your custom group on your personal computer.
  6. The name of the custom group will be automatically entered. Click Save.

TIP: You can only export Customised Data and Geography from the My Custom Data Tab. Only one customised grouping can be downloaded at a time.

6.8 Edit a custom data group outside TableBuilder

To edit a custom group you have created in TableBuilder and then downloaded to your personal computer:
  1. Open the file from the location you have saved it to. The file will open in Excel if you have Excel installed on your computer.
    Note: Some classifications codes in Tablebuilder (e.g. AGEP) have leading zeros. For these classifications once you have exported your file from TableBuilder you will need to open the file in a text editor (e.g. UltraEdit) to make any changes to the file before loading back in, as Excel will remove any leading zeros and the custom group will not load into TableBuilder.
  2. Make any changes to the group; for example, delete an item or add another from that classification.
    Note: If the label and details for any group you wish to add other variables to must be entered correctly or the group will not work.
  3. Save the file as you would normally, keeping the same format.
    Note: If the label and details for a group you wish to add other variables to is entered incorrectly the group will not work.

6.9 Import a custom data group into TableBuilder

To upload a custom group into TableBuilder the group you are uploading needs to be present in the database you are loading it into. For example, you are unable to load a custom group of ages into the dwellings only database because age is not available in that database. You can load it into any of the Persons, Persons and Families or Persons, Families and Dwellings databases.

To upload a custom group you need to be on the My Custom Data screen of TableBuilder.
  1. Go to the My Custom Data and Geography box. If you know the file path to the location of your file type it in the 'upload' text field; otherwise click on the Browse button.
  2. A pop up window will open. Navigate to the location of the custom group you wish to load and click Open.
  3. The Text field next to the browse button will be populated with the location of your file. Click on the Go button.

TIP: You can only import Customised Data and Geography from the My Custom Data Tab. Only one customised group can be uploaded at a time.

If you are successful, your group will appear in the My Custom Data and Geography box under the appropriate classification tree.


In this panel you can also remove any item you don't want in the table by marking the box and then selecting Delete.


To add the group to a table, select the Table View tab and select Customised Table.
You will see your new items listed under Custom Geography.


To add them to a table, select the items and select either Add to Row or Add to Column.


Select Retrieve Data to generate the data.



Unsuccessful Upload screen:
If the upload has been unsuccessful, the Unsuccessful Upload screen will tell you how many rows of the custom group have failed and why. You can download all errors using the button provided and then investigate the reasons for failing.

The table displayed will also tell you why an upload has failed in the Error Message column. The most common reason for a table to fail is that labels do not match. These labels can be altered to match the database you are importing into.

Picture showing Summary of Upload, with the option to download all errors. Each record include information on line number, failing column, column name, column value, error message and line contents.


If you continue to have problems importing a custom group, contact the National Information and Referral Service (NIRS) (see Chapter 11).