How to check if Qlik Gold Client Transformation is Working ?

Miguelsantunes · Sep 24, 2024 6:54:37 AM

Intro

Data Transformation functionality was introduced in Gold Client version 8.0. It allows the transformation of fields during the Export of data in Gold Client. This functionality is delivered with default configuration; however, users are provided the flexibility to define their own data transformation routines for any table and field.

Summary:

When using Qlik Gold Client, you are unsure if the transformation is working.

Here is a step by step to validate all the stages of transformation.

How To Make Sure Transformation is active:

1. Check that the rule(s) exist in /n/HTG/ZGOLD > Data Transform > Transformation Setup.

2. The configuration needs to be active and have a valid rule.

In this example, transformation rule BP01 (designed to transform Business Partner data) is scrambling BUT0CC-CCNUM (Payment Cards Number) and EKUN-SOC_SECURE (Social Insurance Number).

3. Transformation rules only add value if they are assigned to Data Echo and/or Client Construct data types.

This assignment is important because the data transformation will occur automatically during the export process but only for those data types which have a rule assigned.

To provide an example, transformation rule BP01 (designed to transform Business Partner data) could be assigned to Client Construct data type BUSINESS PARTNERS and/or to Data Echo data type CA - BUSINESS PARTNERS.