Working with Joined Data Table Editor

The Joined Data Table Editor allows you to join two or more data tables to create a new joined data table. This editor is composed of the following sections:

Join Data Table Editor Sections and Definitions

Section	Description
1	Back Exit the Joined Data Table Editor and go to the Data Library page.
2	Join Data Table Name Name of the join data table. You can edit by entering a new one and clicking .
3	Join Data Table Settings Description of the data table and the auto refresh period (in seconds).
4	Join Data Table Parameters Add or manage data table parameters. The inherited data table parameters from the joined data tables are displayed.
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 Execute the queries to return and display preview of the joined 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. The inherited calculated columns from the joined data tables are also displayed.
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	Join Settings Allows you to: View the data tables that are being joined and the join keys. Delete any of the data tables by clicking . Hover your mouse cursor over data tables to view their locations.
14	Data Policy Allows you to set the data policy for data tables in the Data Library.
15	Join Type Displays the join type used.
16	Add Data Table Displays the Add Data Table dialog where you can select data tables to join. These data tables were created in the Data Table Editor.
17	Join Key Allows you to select the join keys of the data tables that will be joined.
18	Refresh Preview Allows you to refresh the data preview.
19	Save Join Data Table Saves the join data table definition.
20	Join Types Allows you to define: Left Outer Join Right Outer Join Full Outer Join Inner Join Cross Join
21	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 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 of the data log which includes the data source name, response time, and duration (ms).
3	Parameters Parameters in the data table.
4	Logs Logs of the last query.

Intellectual Property Rights Notice | Technical Support