https://community.qlik.com/t5/Official-Support-Articles/Transformation-Source-Filter-for-Delete/ta-p/1947635 <H4 id="toc-hId--514842870">Environment</H4> <UL> <LI>Replicate</LI> <LI>Table/Field level Filter&nbsp;</LI> </UL> <P>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.</P> <H3 id="toc-hId--525350720">Filter Transformation</H3> <P>A common use of filter expressions is to check a field in the record for a specific value&nbsp; and then either allow or not allow the delete transaction to replicate to the target.</P> <P>The task was set up to filter deletes from the source with a transformation expression to check a field for a value of 1</P> <H4>The complete transformation code as follows</H4> <LI-CODE lang="markup">CASE WHEN $AR_H_STREAM_POSITION != '' THEN CASE WHEN $CompCode=1 THEN 1 END ELSE 1 END</LI-CODE> <P>&nbsp;</P> <H3 id="toc-hId--525350720">Warning Message in task log</H3> <P>Warning message in the task logs:<BR />"Table "Schema.Table" (Subtask 0 thread 1) is suspended. Cannot compute expression, not all column values are in the data record.</P> <H3 id="toc-hId--525350720">Solution</H3> <P>As we were discussing this issue we realized that on a delete statement from the source the only fields that were in the journal were before image fields. There were no after image fields which would have the correct field name "$CompCode"</P> <P>When we changed the filter expression to use the before image field name it worked okay "$BI_CompCode" as the before image was included in the journal entry.</P> <P>&nbsp;<STRONG>NOTE:</STRONG><SPAN>&nbsp; There can be other reasons why a field that is referenced in an expression may not be in the journal or transaction log from the source. If you get an error message like this one you can help debug it by turning on the __CT tables&nbsp;to see what they are receiving&nbsp;from the source.</SPAN></P> Fri, 24 Jun 2022 18:31:28 GMT Michael_Litz 2022-06-24T18:31:28Z https://community.qlik.com/t5/Official-Support-Articles/Transformation-Source-Filter-for-Delete/ta-p/1947635 <P>Replicate, Filter, Transformation, Expression</P> Fri, 24 Jun 2022 18:31:28 GMT https://community.qlik.com/t5/Official-Support-Articles/Transformation-Source-Filter-for-Delete/ta-p/1947635 Michael_Litz 2022-06-24T18:31:28Z