You are here: Tools > Extractor > Create New Extract

Create New Extract

  1. Select the Extractor Icon from the Tool bar, where Extractor presents the Navigator in the same way as the Navigator.
  1. Using the Available Fields tree view you can select all fields required for your Extract.
  2. Open the Information folder to display the fields and double-click on the field required to add it to your Extract.
  1. To remove a field from your Extract (if it was selected by mistake), highlight the field in the Selected Fields box, and click on the left arrow button ( < ).
  2. If you are familiar with SQL you can edit the Extract's SQL statement directly by selecting the View SQL tab. - Note: this option is dependent on security setup and recommended for advanced users
    • The Criteria tab allows you to specify criteria to be applied to the selected field.
    • The Sort tab allows you to control how the data is sorted.
    • The Display tab allows you to specify which fields will and will not be displayed on the Extract.
  1. Your Extract is now ready to run, or to be saved for future use.