Filter scope

In the Filter Scope screen of the New Filter Rule wizard, you define which tables will be filtered. For example, you can limit the filter to all tables that contain the word SALARY as part of their name.

The options displayed in this screen depend on selected filter type.

Scope options when filtering by columns

The following table describes the options that are available when filtering by columns.

Columns filtering scope
Option	Description
Schema name is like %	Leave the % sign to apply the rule to all source schemas (the default). Alternatively, enter a custom string. The rule will only be applied to columns in schemas that match the specified string. For example, enter HR to include only columns that belong to schema HR. You can use the % symbol as a wildcard. For example, specifying H% will include all columns in tables that belong to schemas beginning with the letter H, such as HR, HELLO, or HQ. The % wildcard can be used in any position. For example, if you use it at the beginning (%H), then the rule will be applied to all columns in schemas that end with the letter "H". The % symbol can also be used in the middle of a string. Information note If you are using an Oracle target, you must enter a schema that exists on the target endpoint. Qlik Replicate does not create new schemas on an Oracle endpoint. If you want to use a new schema for the target, create the schema on the Oracle endpoint before running the task. For more information, see Using Oracle as a target.
Table name is like %	Leave the % sign to apply the rule to all source tables (the default). Alternatively, enter a custom string. The rule will only be applied to columns in tables that match the specified string. You can use the % symbol as a wildcard. For example, specifying J% will include all columns in tables with names beginning with the letter J, such as JOBS, JOBS_HISTORY, or JACKSONVILLE. The % wildcard can be used in any position. For example, if you use it at the beginning (%H), then the rule will be applied to all columns in tables that end with the letter "H". The % symbol can also be used in the middle of a string.
Column name is like %	Leave the % sign to apply the rule to all source columns (the default). Alternatively, enter a custom string. The rule will only be applied to columns that match the specified string. You can use the % symbol as a wildcard. For example, specifying N% will include all columns with names beginning with the letter N, such as NAME, NAME_FIRST, or NAME_LAST. The % wildcard can be used in any position. For example, if you use it at the beginning (%n), then the rule will be applied to all columns that end with the letter "n". The % symbol can also be used in the middle of a string.
Data type is	Optionally, select a specific data type from the drop-down list. Make sure the data type you select is compatible with the data in that column. For a description of Qlik Replicate data types, see Replicate data types. For information about data type mapping from the native endpoint to Qlik Replicate data types, see the chapter for the endpoint you are using. For a list of endpoints supported by Qlik Replicate, see Supported Platforms and Endpoints.
Scope expression	Click Advanced options to define a scope expression using the expression builder.

Scope options when filtering by record attributes

The following table describes the options that are available when filtering by record attributes.

Record attributes filtering scope
Option	Description
Schema name is like %	Leave the % sign to apply the rule to all source schemas (the default). Alternatively, enter a custom string. The rule will only be applied to columns in schemas that match the specified string. For example, enter HR to include only columns that belong to schema HR. You can use the % symbol as a wildcard. For example, specifying H% will include all columns in tables that belong to schemas beginning with the letter H, such as HR, HELLO, or HQ. The % wildcard can be used in any position. For example, if you use it at the beginning (%H), then the rule will be applied to all columns in schemas that end with the letter "H". The % symbol can also be used in the middle of a string. Information note If you are using an Oracle target, you must enter a schema that exists on the target endpoint. Qlik Replicate does not create new schemas on an Oracle endpoint. If you want to use a new schema for the target, create the schema on the Oracle endpoint before running the task. For more information, see Using Oracle as a target.
Table name is like %	Leave the % sign to apply the rule to all source tables (the default). Alternatively, enter a custom string. The rule will only be applied to columns in tables that match the specified string. You can use the % symbol as a wildcard. For example, specifying J% will include all columns in tables with names beginning with the letter J, such as JOBS, JOBS_HISTORY, or JACKSONVILLE. The % wildcard can be used in any position. For example, if you use it at the beginning (%H), then the rule will be applied to all columns in tables that end with the letter "H". The % symbol can also be used in the middle of a string.
Scope expression	Click Advanced options to define a scope expression using the expression builder.

After defining the filter scope, click Next to proceed to the Transformation action screen.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here