Altair® Panopticon

 

Working with Data Table Editor

 

Most of the sections in this editor are available in Workbook Internal Data Table Editor. However, you can only create a single data table in this editor. To join data tables, you can use the Joined Data Table Editor.

 

 

Data Table Editor Sections and Definitions

Section

Description

1

Back

Exit the Data Table Editor and go to the Data Library page.

2

Data Table Name

Name of the data table. To modify, use the Rename option in the context menu.

3

Data Table Settings

Displays the data source that you will connect to. Click  to select another data source. Other data table definitions are displayed including the description and the auto refresh period (in seconds).

4

Data Table Parameters

Add or manage data table parameters.

5

Search Columns

Allows searching of columns on the Data Preview.

6

Collapse Data Profile Pane

Collapse the Data Profile pane. Click to expand the Data Profile pane.

                 7

Data Profile Pane

Displays the following information:

·        Rows of Data Profile (i.e., Value Count, Distinct, Missing)

·        Data Profile Histogram

8

Data Preview

Executes the queries to return and display preview of the data table you are creating.

NOTE: The maximum number of rows displayed in the Data Preview is 100.

9

Calculated Columns

Allows you to view and manage the calculated columns.

10

New Column Options

Allows you to add any of the following columns:

·        Auto Key

·        Calculated

·        Ranking

·        Time Bucket

·        Identity, Sign, Manual, Equal Density, and Equal Distance numeric buckets

·        Text Grouping

11

Group and Sort Columns

When the Column Order is set to Sorted, the columns are grouped by type (Text, Date/Time, then Numeric) and sorted alphabetically.

12

Column Profiling

Perform column profiling either for the Top 1000 Rows or All Rows.

13

Connector Settings

Displays the connector settings of the data source and allows for limiting the amount of data to be returned.

14

Import to Data Store

Allows you to import the data table to a data store.

15

Save Data Table

Saves the data table definition.

16

Row Limits Settings

Allows setting of the row limit of data sources.

17

Refresh Preview

Allows you to refresh the data preview.

18

Collapse Data Preview

Collapse the Data Preview pane. Click  to expand the Data Preview pane.

 

Clicking Transform Settings  displays the Transform Settings pane.

 

 

Section

Description

Transform Settings

Allows you to:

·        Pivot or unpivot retrieved data.

·        Transform data to enable time series analysis including interpolation.

·        Run an R or Python script for data transformation.

·        Lists of orders to be reconstructed into an Order Book and conflated for output display.

 

Clicking Columns  displays the Columns Settings pane.

 

Section

Description

Columns Settings

Allows you to:

·        View the column data type

·        Rename the column names

·        Select the numeric or Date/Time format

·        Select the numeric default aggregation

·        Define the Min and Max range of numeric columns

·        Define custom sort order

 

Clicking Advanced  displays the Advanced Settings pane.

 

 

Section

Description

Advanced

Allows you to:

·        Enter custom Error Message that will be displayed when an error occurs while fetching data. Can be parameterized.

·        Retrieve external aggregates