Define Data Source
After data is prepared, you can use them as the data source to perform computations on the ETL file.
Import Data
SourceA ETL file’s data source can be a database table, a text file, an Excel
file or a bin file. Take the database table as an example. Open a new ETL file,
click Edit -> Database Table or Database Table icon 
on the toolbar to enter Database
Table interface, as shown below:
Result Name: Define result set name.
Result Type: For specifying the result set type, which can be table sequence or cursor. There are different methods for computing different types of result sets.
Data Source: Select a data source, which is configured in Tool -> Data Source. All connected data sources are displayed in the drop-down list.
Table: A table to be selected from the Data Source.
Add quotes to table: You can choose whether to add quotes to the table name or not. When the table name contains special characters, collides with the keyword, is case-sensitive, has the cross-database compatibility problem, you need to enclose the table name in quotes to retrieve data correctly.
Type of Quotes: Select the type of quotes – double quotes, single quotes or MYSQL.
With configurations in the above figure, click OK button and a result set is generated as follows:
Under ETL, the source table structure lists the first five fields. Click the source table structure table and you can view all its data in the result set interface on the right.
Enter the Import configuration interface to
import data from a text file/Excel file/bin file source through the Edit
menu or icons 
on the toolbar. The
configurations are similar to those for the Special Open (Refer Prepare data - Diverse data sources).
Forward
On the
result set interface on the right, click Forward icon 
to open the next layer of data.
Backward
On the
result set interface on the right, click Backward icon 
to return to the previous layer of data.
Field Contents
On the
result set interface on the right, click Preview icon 
to preview the detailed contents corresponding to the currently selected
data.
Copy Data
On the
result set interface on the right, select a field value and click Copy
icon 
to copy the current row of data to the clipboard. If no values are
selected, copy this icon and all data will be copied to the clipboard.
Copy Column Names
On the result set interface on the right, click Copy Column Names
icon 
to copy
all column names to the clipboard.
Browse Graphs
On the result set interface on the right, click Browse Graphs icon 
to display data in the
current page as a graph. For example:
The available types of graphics are column, pie and line. You can define the category field, series field and value field as needed, and make personalized configurations for the graph properties, as shown below:
Click Copy button and you can copy the graph to clipboard; or click Save as button to save the graph as a svg file.
Zoom
On the result set interface on the right, right-click to select Zoom to display the current result set interface at a particular scale.
Format Column
To set a currency format for SALARY column, for example, right-click SALARY column on the result set interface and select Format Column:
Click OK and get the following result:
