Managing Data Sources
A data table can consist of one or more data sources and can be connected directly, with data retrieved on the fly as it is required.
Click on a data source on the Data Sources pane. The currently selected data source is highlighted (grey background) and the settings are displayed.
Connector Settings
Sample 1
Sample 1 (Text Data – Manual Text) displays the text values and the properties of the generated columns based on the set properties (i.e., Skip First n Rows, Data Type Discovery, Text Qualifier, and Column Delimiter)
Sample 2
This lists options specific to the data source. In the case above for Sample 2 (MS Excel), it lists the file path to the Excel workbook, and the sheet to be used.
In the Connector Settings pane, the amount of data to be returned can also be specified.
For more information on the data source specific settings, refer to Data Connectors for more information.
Transform Settings
Clicking the Transforms Settings button displays the transform settings of the currently selected data source.
Transform Settings allows you to:
- Pivot retrieved data
- Unpivot retrieved data
- Transform data to enable time series analysis including interpolation
- Run an R or Python script for data transformation
- Run a REST Transform
- List of orders to be reconstructed into an Order book and conflated for output display
Columns Settings
Clicking the Columns button displays the retrieved columns from the data source.
Column Settings allows you to:
- Modify the column data type
- Rename column names
- Select the numeric or Date/Time format
- Select the numeric default aggregation
- Define custom sort order
(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.