Global expressions are not propagated to all tables.
Defining a soft delete transformation can be done on each individual table as needed. However, if you want to do it for all tables in the task you will want to use a Global Transformation.
The issue manifested when defining a Global Expression to do a soft delete.
The field is supposed to be automatically added to all tables in the task. The field was not added to all tables. It was random results as some tables had the field and others did not.
When reviewing the process of defining the expression we noticed there are two screens which would allow you to enter the expression.
When we used both the Transformation Scope / Advanced Options screen and the Transformation Action / Value screen, not all tables got the field.
Example: Transformation Scope, with Advanced Options expanded:
Use Transformation Action > Value instead and leave the Transformation Scope > Advanced option blank.
This resulted in all tables getting the field added.
If you have already entered the expression in the Transformation Scope > Advanced Option, remove the expression.
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.
Transformation - Operation Indicator - Archive User - Soft Delete