Build Select Query

The Build Select Query feature is used to define a smaller subset of data for uploading.

1. From the Custom Table Loads > Tables to Transfer tab, click the Criteria field of the desired table. The Build Select Query panel appears.
2. Use the following table to enter data in the Build Select Query panel:

Field	Description
Column Name	Click the drop-down list, and, select the column on which to base the criteria definition.
Operator	Click the drop-down list, and, select the operator. Valid values are: = (equal) <> (Not Equal) > (Greater Than) >= (Greater Than, and Equal To) < (Less Than) <= (Less Than, and Equal To) Like Between In
Data Values (no label)	Click the drop-down list, and, select the value to apply to the operator, or, type the value if it is not in the drop-down list.
Criteria Results (no label)	Displays the selection criteria definition. Modify the criteria as necessary.


3. When all criteria fields are entered, select one of the following options:
• Add into Criteria: adds the criteria.
• Or into Criteria: adds the criteria as an OR statement.
• And into Criteria: adds the criteria as an AND statement.
4. Repeat the process until all criteria is specified.
5. To save all changes and close the panel, click OK.