Open a data extraction file, click View relations icon and then Add icon to get the following Relation name dialog box:
Enter the view relation name and click [OK] to finish the edit.
Select the newly-created view relation and drag a data source to the right. If there is a join, drag the fact table (a detail table or a subtable) first and then the table associated through a foreign key.
●Example: Create a view relation based on ATTENDANCE table, EMPLOYEE table and DEPT table.
1. Create a database table source using ATTENDANCE table, EMPLOYEE table and DEPT table in demo database. The settings are shown below:
2. Create a new view relation named ExportDefine1. Drag the EMPLOYEE to the right:
3. Drag ATTENDANCE to the right and add joining fields on the Relation setting pop-up:
There are two join types – inner join and left join. Select Remove duplicate key values to delete duplicates from target field values.
4. Click [OK] and then drag DEPT to the right. Add joining fields on Relation setting pop-up:
5. Click [OK] to complete the creation.
A single data source can be treated as a view relation to export data in a file or a database table to a composite table, a bin file or a database table.
l Relation name
Open a data extraction file, select a view relation and click the Edit icon to open Relation name dialog box:
Click [OK] to complete the edit.
l Relation settings
Click a view relation and double-click or right-click the target table on the right:
Click [Edit] to change the joining type and joining fields for associating the source table and the target table on the pop-up. Click [Delete] to delete a target table. Right-click the source table and select [Delete] to remove both the source table and target table. Click [Expand] to display all tables and Click [Collapse] to fold up all tables.
Open a data extraction file, select a view relation, click delete icon and the following prompt appears:
Click [Yes] to delete the view relation, and [No], or the cross sign X at the upper right corner, to refuse the operation.
Open a data extraction file, select a view relation and click the shift-up icon to move it up. View relation ExportDefine2 is selected below:
Open a data extraction file, select a view relation and click the shift-down icon to move it down. View relation ExportDefine1 is selected below: