Example of using Character Substitution in Replicate

KellyHobson — Thu, 24 Mar 2022 15:54:41 GMT

Within Replicate Task Settings -> Character Substitution you have the option to substitute or delete source characters.

Note- All characters must be specified as Unicode code points.

Task is a Postgres Source to Snowflake target.

Source:

In the first example, we replace letter 'X' to 'R'.

Ref: https://www.utf8-chartable.de/

Target output:

In the second example, we delete the letter 'X'.

Target output:

Environment

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

article Example of using Character Substitution in Replicate in Official Support Articles

Example of using Character Substitution in Replicate

Environment