topic Operation Indicator as New column in Qlik Replicate

Operation Indicator as New column

DeepakS — Mon, 17 Apr 2023 17:59:42 GMT

Hello,

Iam a newbie. Trying to add a new column using Global Rules.

Trying to get the Operation Indicator values into a column. Below is the expression of the column value.

Add column
	for %.%
	Column 'REPLICATION_PROCESS_CD', data type STRING(50) and sub type Regular
        Value: operation_indicator("D", "U", "I")

But I see null data going in to the column Replication_Process_Cd during Full load. I was expecting "I".

Help me out here.

Re: Operation Indicator as New column

Michael_Litz — Mon, 17 Apr 2023 18:04:38 GMT

Hi @DeepakS ,

Please try this case statement:

CASE ifnull(operation_indicator('D', 'U', 'I') ,'NULL')
WHEN 'NULL' THEN 'I'
ELSE operation_indicator('D', 'U', 'I') END

If this solution worked for you please mark the case as solution.

Thanks
Michael Litz

Re: Operation Indicator as New column

Steve_Nguyen — Mon, 17 Apr 2023 18:06:09 GMT

@DeepakS

we have many forum article on this :

https://community.qlik.com/t5/Official-Support-Articles/Transformation-Operation-Indicator-Archive-User-Soft-Delete/ta-p/1969998/message-revision/1969998:4

https://community.qlik.com/t5/Qlik-Replicate/operation-indicator-DELETE-UPDATE-INSERT-vs-header-operation-in/td-p/1969870

Re: Operation Indicator as New column

DeepakS — Wed, 19 Apr 2023 17:23:44 GMT

Thanks @Michael_Litz !

Case statement helped. If I understand correctly, we are expected to get NULL during Initial Full load for the Operation Indicator. Which we are handling it manually using the CASE statement.

I have setup unidirectional sync. Would we even see any "D" (Delete)? I assume as soon as the record is deleted, it will be deleted in target too. Hence I assume we wont even see the D.

Re: Operation Indicator as New column

Michael_Litz — Wed, 19 Apr 2023 17:30:08 GMT

Hi @DeepakS ,

The operation indicator will do a soft delete on the target so that the record will still be on the target with the "D" in the field.

Here is another article that should help explain:
https://community.qlik.com/t5/Official-Support-Articles/Filter-Deletes-in-Replicate/ta-p/1801945

Thanks,
Michael Litz