Operations on a resulting view

Read(29) Label: add, edit, delete,

Add

Open a data extraction file, select a view relation on View relations window and click :

Here’s the pop-up for setting the view output:

Name - View relation result name.

Output type – The way of outputting a resulting view. [Append] adds data in the view to an existing file; [Overwrite] deletes data in an existing file and writes the result to it.

Output to – Which type of file to which you want to output the resulting view. There are multiple choices – CTX (a composite table file), BTX (a bin file), TXT (a text file), CSV, XLSX (an Excel file), and a database table.

File name – When you want to output a resulting view to a CTX file,a TXT file, a CSV file, an XLSX file or a BTX file, click  to select the path of the would-be output file and edit its name.

Export headers When the to-be-exported file is a TXT file, a CSV file, or an XLSX file, select this option to export the first row as column headers.

Data source – The data source that contains the database table to which you want to output the resulting view.

Table – The database table to which you want to output the resulting view.

Click [OK] and Selected fields and alias and Computed columns will appear:

Now you can select all or part of the fields and set aliases for them, or edit computed columns.

Preview view

Open a data extraction file, select a view relation and click Preview view to view data:

Edit

Open a data extraction file, select a view relation and click edit icon  to open the ViewOuput settings box:

You can configure how to output a view on the above box. Then click [OK] to complete the configuration.

You can modify the selected fields and their aliases or edit the computed columns on the right.

Delete

Open a data extraction file, select a view relation, click delete icon  and the following box appears:

Click [Yes] to delete the resulting view and click [No], or the cross sign at the upper right corner, to reject the deletion.

Shift up

Open a data extraction file, select a view relation and click the shift-up icon  to move it up. View relation ViewOut2 is selected below:

 

Shift down

Open a data extraction file, select a view relation and click the shift-up icon  to move it down. View relation ViewOut1 is selected below: