Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
we have many forum article on this :
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.
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