How to use Table Holder objects

Table Holder objects are similar to Data Holder objects except they are used to hold tabular data rather than single values. The schema of the table can be defined by the user OR can be imported or copied from an existing file (for example Excel or CSV). To add a Table, Right-click on Core (or any other object that supports children) and select Admin → New → Data Processing → Table Holder from the context menu.

Adding a Table Holder
Figure 1. Adding a Table Holder

In the Create Table Holder wizard, give the object a name and click Create.

Create Table Holder wizard
Figure 2. Create Table Holder wizard

Select the Table Holder in the I/O Model panel and click on Table Data "…" in the Object Properties panel to open up the Table Data dialog.

Adding Table Data to the Table Holder object
Figure 3. Adding Table Data to the Table Holder object

Using the Icons in the menu bar of the Table Data dialog, rows and columns can be added to the table. This allows you to create the schema you wish for the table.

Adding Rows and Columns using the Menu Bar
Figure 4. Adding Rows and Columns using the Menu Bar

Add columns and rows to the table. You will notice that only one row can be added at a time until you start to enter some data into the table rows. Enter some data values into the table. Once some columns and rows have been added, the Delete Column and Delete Row buttons become available in the menu bar.

Adding and Deleting Columns and Rows
Figure 5. Adding and Deleting Columns and Rows

You can add headers to the columns by clicking on the tops of the columns and entering the name. Once table data is entered it is possible to export to an Excel, CSV or JSON file using the export button.

Adding Headers and Export Data
Figure 6. Adding Headers and Export Data

To save the data you have entered to the object, click Apply at the bottom of the dialog. This closes the Table Property dialog and saves the changes to the server. Click Ok if you want to save the table data and return to the Object Properties panel, you can click Apply there to save the changes to the server.

Applying the Table Data
Figure 7. Applying the Table Data

The table data is saved to the Table Data property of the object:

Table Data Property
Figure 8. Table Data Property

The Table Data property can be set using Lua, the value must be a JSON string conforming to a particular schema. Please visit the Lua Scripting part of the documentation for more details.