Data Views in a Data Table

This tutorial shows the data views for a data table

Example workspace: Data View Example Workspace‚Äč

The workspace linked above contains four tables, with different data views. To set the data view, you select from the "Data View" dropdown on the properties dialog box, either when creating the table or when you edit the properties of the table.

The data view selected does not affect the value or internal mechanics of the table, other than how the value is presented.

  • gridTable - This is a data table with the view set to Grid. It shows the value of the table in a grid, like a spreadsheet. This makes it easy to paste in value from a spreadsheet, or copy values to a spreadsheet.

  • jsonOfGridTable - This is a data table with a standard JSON view (colorized). The formula gives it the same value as gridTable. This shows you the JSON structure of the value. Here it is an array of arrays.

  • textDataTable - This is a data table with the view set to Text Data. This is good when you want to work with text and not format it like a JSON.

  • jsonOfGridTable - This is a data table with a standard JSON view (colorized). The formula gives it the same value as textDataTable. This shows you the JSON structure of the value. Here it is the text value with start and end quotes, and proper escaping inside.

You can also change the data view of any table by going to "Edit Properties" (click on the icon in the table upper left to get the menu) to see the different views of the data for a given table.