Unify and manage your data

Mapping example 8

Filtering attribute values

Attribute values can also be filtered on the DT so they do not get copied to the CT.

In this example, the DT has Address Ranks going from one to 10. If you only want DT addresses that have Address ranks of only 1 or 2 to copy to the CT, you can filter them using the filter property as shown here.

Advanced Filtering

There are a variety of different expressions that can be used to do more sophisticated filtering of attribute values. The “query” key can be used to perform more advanced filtering functions.

In this example, any IDs that contain characters that are not specified in the regexp (regular expression) will be excluded from the CT. You can use this expression to ensure that characters that are not supported in the CT are not copied from the DT to the CT.

There are a number of filters that can be used as shown below.

For more information on Filtering options, see topic Filtering Entities.