topic Re: preventing a column from update in Qlik Replicate

preventing a column from update

Denial — Thu, 02 Mar 2023 10:01:12 GMT

Hi ,

Is there any option to prevent particular column from update

Target :- SQL

Thanks,

Re: preventing a column from update

john_wang — Thu, 02 Mar 2023 13:32:29 GMT

Hello @Denial ,

Thanks for reaching out.

Not very sure how the target table column was defined however there are different options:

1- Remove the column from table transformation then the column will not being updated

2- if the column has existing value and you want to keep it as is, then update the column with existing value by using target_lookup function. A very good sample : Target Lookup - Insert_Date

Hope this helps.

Regards,

John.

Re: preventing a column from update

Jon_Donker — Thu, 02 Mar 2023 21:48:11 GMT

Hi,

Do you mean if a particular column changes value - don't capture the change?

We have tasks like this that only capture changes for particular columns. We have to add filters like the following in our tasks:

($AR_H_OPERATION != 'UPDATE') OR ( ($AR_H_OPERATION == 'UPDATE') AND ( ( $BI__COLUMN1 != $COLUMN1 ) OR ( $BI__COLUMN1 IS NULL AND $COLUMN1 IS NOT NULL ) OR ( $BI__COLUMN1 IS NOT NULL AND $COLUMN1 IS NULL ) OR ( $BI__COLUMN2 != $COLUMN2 ) OR ( $BI__COLUMN2 IS NULL AND $COLUMN2 IS NOT NULL ) OR ( $BI__COLUMN2 IS NOT NULL AND $COLUMN2 IS NULL ) OR /* We're not capturing changes on Column 3*/ ( $BI__COLUMN4 != $COLUMN4 ) OR ( $BI__COLUMN4 IS NULL AND $COLUMN4 IS NOT NULL ) OR ( $BI__COLUMN4 IS NOT NULL AND $COLUMN4 IS NULL ) OR ( $BI__COLUMN5 != $COLUMN5 ) OR ( $BI__COLUMN5 IS NULL AND $COLUMN5 IS NOT NULL ) OR ( $BI__COLUMN5 IS NOT NULL AND $COLUMN5 IS NULL ) ) )