Qlik Replicate: Dropping and Readding the Same Column Value

[Dana_Baldwin]

Qlik Replicate does not support using a transformation to rename a column and then adding a new column with the same name. See Defining transformations for a single table/view for more information.

Similarly, dropping a column and then adding a column with a different name, but populated with the dropped column's value, is also not supported.

This approach will not work, as you've already told the task to discard the column and its value. At a minimum, this will cause the task to switch to transactional apply mode (one-by-one), but may cause other potential issues.

Resolution

If the column values are needed on the target with a different column name, simply rename the column instead of dropping and then re-adding them.

Environment

• Qlik Replicate