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.
In the Create Table Holder wizard, give the object a name and click Create.
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.
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.
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.
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.
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.
The table data is saved to the Table Data property of the object:
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.