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
I have similar question. Global Transformation for soft delete works for me but when delete operation becomes update to soft delete the record it just retains the primary key columns and wipes out all other columns of the table. How can I retain other columns ?