Edit Data Source

After you finish adding data sources, select a source table and click Edit button (), or just double-click the source table to perform import setup on the source table.

  In the interface below, you can set up the database table source – name, fields to be imported, and primary key:

Select fields and click Field Analysis to compute the maximum value, the minimum value, the distinct count and the total count on the current field. To perform these operations on GENDER field, for example:

Below is the interface for setting up text file source, where, besides specifying the file name, fields to be selected, primary key, and performing analysis on fields, you also configure character set, separator and sorting field:

Check for Orderliness: Check whether data in the current text file source is ordered by the selected fields, which are already ordered。

Import the first row as field names: Use the first row as field names at import. Use _1，_2,… as field names when the option isn’t selected. The option is by default checked.

Remove quotation marks: Delete quotation marks from both sides of each data item, including items in headers, but leave quotation marks within data item alone.

Use double quotation marks as escape character: Use the standard Excel escaping rule to transform the two pairs of double quotation marks to one pair while leaving other characters alone.

Keep leading and trailing spaces: Keep white spaces at both sides of each data item; by default, they will be automatically deleted.

Select all fields, set DEPT as the primary key, check Ordered for it, select Import the first row as field names, and click Check for Orderliness: