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. You can edit by entering a new one and clicking .
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	Data Policy Allows you to set the data policy for data tables in the Data Library.
15	Import to Data Store Allows you to import the data table to a data store.
16	Clear and Import to Data Store Allows you to clear the earlier imported data and import again to the data store.
17	Save Data Table Saves the data table definition.
18	Row Limits Settings Allows setting of the row limit of data sources.
19	Refresh Preview Allows you to refresh the data preview.
20	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 perform the following:

Pivoting or unpivoting retrieved data.
Transforming data to enable time series analysis including interpolation.
Running 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

Column Settings

Allows you to perform the following:

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
1	Error Message Allows you to enter custom Error Message that will be displayed when an error occurs while fetching data. Can be parameterized.
2	Includes Aggregate Data Allows you to retrieve external aggregates.
3	Export Raw Data Specify the set of columns to be included when exporting raw data

Clicking Debug displays the Debug pane.

Section	Description
1	Data Table ID Id of the data table. Can be used for parsing of server logs.
2	Data Log Details Details of the data log which includes the data source name, response time, and duration (ms).
3	Parameters Parameters on the data table.
4	Logs Logs of the last query.

Intellectual Property Rights Notice | Technical Support