Filtering Data When Exporting

You can use filters to narrow the data that is included when you export records.

To filter data when exporting:

1. Open the screen that displays the kind of data that you want to export.
2. Click Options > Export.

   The Export screen appears.

3. Click the Filters tab.
4. In the Column field, specify a field that will be exported. More...

   You select from a list of fields that can be exported from the screen. For example, when exporting data from the Currency Codes screen, the following fields are available:

   • Currency Code
   • Description
   • Symbol
   • Decimal Places
   • Symbol Position
   • Thousands Separator
   • Decimal Separator
   • Negative Display
5. Click Add.

   The field name is added to the table of filters, in the first empty column.

6. In the new column, click Add criteria.

   The Create filter for field screen appears.

7. In the first field, select a relational operator. More...

   You can select from the following relational operators:

   Symbol	Meaning
   =	Equal to
   !=	Not equal to
   >	Greater than
   >=	Greater than or equal to
   <	Less than
   <=	Less than or equal to
   LIKE	Use this operator to find a group of characters or a single character. The default setting is for a group of characters. The program inserts a % (percent sign) after the value you enter in the next field. To find a single character, enter _ (the underscore character) after the value. Tip: To select a field name as the value, select the Set value as field name option. The second field then contains a drop-down list from which you can select any available field name.

8. In the second field, enter a value to which the operator relates.

   For example, if you were creating a filter for the Currency Code field, and you entered <= in the first field and 900 in the second field, the filter would find any currency code lower than 901.

9. Click OK.

   The filter appears in the table and the Results Preview tab lists records that will be included in the export, based on the filters you've created.

   Tips:

   • You can add multiple filters for a single field. For example, to find currency codes between CAD and USD, you could enter two filters for the Currency Code field:

     > CAD

     < USD

   • Click Show Filter to see the filters you've created as a string of code. This can be used in various ways (for example, as part of a SQL statement).

10. Click Export to export filtered data.

    The export includes only records that match:

    • At least one of the filters in a vertical column.
    • All the conditions in a horizontal row.

Published: September 11, 2020
© 2020 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks