Qlik Replicate Global Transformation: How to replace null values in a field

[Michael_Litz]

A Global Transformation can replace null values in all fields within a task. The example and expression used in this article will detect null values and replace them with a hard-coded string 'myNull' in all fields in the task.

Table-level transformations on a specific field will override this transformation since it globally defined.

1. In the Qlik Replicate Web Console, access the Global Rules tab
2. On the Transformation Scope step, set all scope variables to wildcard, meaning it will apply to all fields: 
   
   
   
   
3. On the Transformation Action step, use the global table-level field that represents the data value:
   
   $AR_M_SOURCE_COLUMN_DATA
   
   
   
   Enter the expression with the replace using the above field:
   
   ifnull($AR_M_SOURCE_COLUMN_DATA,'myNull')