Data Connection Dataset
A data connection dataset refers to a dataset created using a data connection as the data source. You can perform row-level selection, processing, and filtering operations on the data by setting filter conditions to choose the required data. The filtering functionality supports both simple filtering and expression filtering.
Create Dataset
Follow the steps below to create a dataset using a data connection.
On the dataset interface, click "New Dataset" and select "Data Connection."
Select the data connection to be used for creating the dataset.
If the desired data connection is not found, contact the data administrator to authorize the required
Data Connection
for use.Edit the dataset content. You can define dataset conditions and filter dataset content using filter criteria. Both simple filtering and expression filtering are supported.
- Simple Filtering: Users can set filter criteria through options. When there are multiple filter criteria, you can choose the condition selection method: 'All Conditions' or 'Any Condition.' 'All Conditions' means the filtered data must meet all filter criteria. 'Any Condition' means the filtered data only needs to meet one of the criteria.
- Expression Filtering: Users can set filter criteria through expressions, allowing for more flexible data filtering. Filter expressions must return a Boolean value. On the right side of the expression editing area is a function list available for use in expressions.
Note
After writing the filter criteria, you must preview the data before proceeding to the next step.
- Simple Filtering: Users can set filter criteria through options. When there are multiple filter criteria, you can choose the condition selection method: 'All Conditions' or 'Any Condition.' 'All Conditions' means the filtered data must meet all filter criteria. 'Any Condition' means the filtered data only needs to meet one of the criteria.
Click "Next" to enter the data structure configuration page, where you can select fields, set field aliases, and define field types.
Note
- Fields that are unchecked will be stored in the dataset in a hidden form. Users can display these fields when needed.
- You can enable the acceleration engine to import the dataset into the acceleration engine.
After clicking "Import," edit the dataset name to complete the dataset creation. You can view the dataset on the dataset page and perform related Dataset Management operations.