Moving certain columns from source to target

[MdFazil]

Hi, I'm new to Qlik replicate. I always wonder that can replicate move only certain or required columns alone to target table. I have gone through the internet but found nothing. Can anyone please clarify me this?

[dommiiii]

Thanks again John.

So assume DDL is set to "Alter target table" and we unmark "By default include all columns"
and choose just particular columns which we need use. And task runs for a while, and later on additional columns are added to DB2/zos. So then new schema will include all columns, "By default include all columns"  ticked again,  and particularly chosen columns will be reset to default (all columns selected and used)?

Is only reason for button "By default include all columns", to remove all columns from target table faster?

Best Regards,

Domile

[john_wang]

Hello @dommiiii ,

Button "By default include all columns" is used to remove all columns (Except the PK columns) from target table faster.

Regards,

John.