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.
Users who initiate exports do not need to take any actions for transformation to occur because of this rule assignment.
4. During the Export, please make sure that the transformation rule(s) is/are being called. Go to the job monitor (SM37) of the main job and check the job log.
For more information, see the Data Transform User Guide found at:
Data Transform User Guide 8.7
Tags:
- Qlik Gold Client
- Transform data
- Scramble data
- Anonimization
- SAP
- S4HANA
Labels
Environment
- Qlik Gold Client 8.7
- SAP S4 HANA
- SAP ERP