Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More

How to check if Qlik Gold Client Transformation is Working ?

cancel
Showing results for 
Search instead for 
Did you mean: 
Miguelsantunes
Employee
Employee

How to check if Qlik Gold Client Transformation is Working ?

Last Update:

Sep 24, 2024 6:54:37 AM

Updated By:

Miguelsantunes

Created date:

Sep 30, 2024 9:44:57 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. 

 

Miguelsantunes_0-1727172934270.png

Miguelsantunes_1-1727172934271.png

 

 

     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). 

Miguelsantunes_2-1727173010629.png

 

 

     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. 

 Miguelsantunes_3-1727173050575.png

 

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 

 

Miguelsantunes_4-1727173081320.png

Miguelsantunes_5-1727173081321.png

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. 

 

Miguelsantunes_6-1727173154931.png

Miguelsantunes_7-1727173154933.png

Miguelsantunes_8-1727173154935.png

 

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
Labels (1)
Version history
Last update:
2 weeks ago
Updated by: