You can set up a syntax that will select only records with specific values. Check Figure 5 for an example. You can specify what field you want to filter on and then specify a value. An operator will be The field in this case is City and the value is Barneveld. The syntax of the filter is as follows: City='Barneveld' The example doesn't have spaces in the fieldnames, but if you used City Name instead of City, you would have to do this: [City Name]=’Barneveld’ (Note the square brackets). Structure: [Column][Operator][Value] The column is the fieldname. The value speaks for itself. The operator however is a little different. NOTE: the value needs to be between single quotes, otherwise ETL+ will recognize it as a field. However, if the value is a number (1, 48, 999) the quotes aren’t necessary. If the fieldname contains a space or a special character, you need to put square brackets around the name: [Field A] or [Field-A] Operators There are a number of different operators that can be used to get the right data. The example in Figure 5 has a filter that only shows people that live in Barneveld. Possible combinations are:
- = (equals)
- <> (not equals)
- like This operator is (mostly) used with wildcards(%). For example: FieldA = ‘Server%’ will return all records in FieldA that start with Server; ServerABC, Server123 but not ADServer123. It is also possible to put more wildcards in a filter: FieldA = '%Server%'. It will return all records that contain Server in FieldA. Example: ADServer123, DBServer, Server123.
There can also be NULL values in a database. You can use them in a filter as well. For example: FieldA is not NULL. This will return all records that do not have NULL values in FieldA. FieldA is NULL will do the opposite. It is possible to use multiple operators by putting brackets around the filter. For example: (FieldA = 'System123' or FieldB = 'Server')