Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
MdFazil
Partner - Contributor III

Moving certain columns from source to target

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?

Labels (2)
2 Solutions

Accepted Solutions
john_wang
Support

Hello @MdFazil ,

Thanks for reaching out to Qlik Community!

Yes, we may replicate only interested columns rather than all the columns. By default Qlik Replicate include all columns in the task design. You may simply to remove some columns from the table transformation for example I'd like to remove the column "NOTES" from the replication:

john_wang_1-1709185798819.png

After the column "NOTES" is removed from the design, the table has 2 columns in target side.

Certainly in some scenarios you may want to add some additional columns eg the transaction datetime, and other computed columns etc. see User Guide Overview of the Expression Builder.

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

Yadunandan
Support

Hello @MdFazil 

Yes it is possible, you need to select the tables which you require to replicate in the table selection window while setting up a task. please see selecting tables  for more information.

Regards,"
Yadunandan

View solution in original post

5 Replies
john_wang
Support

Hello @MdFazil ,

Thanks for reaching out to Qlik Community!

Yes, we may replicate only interested columns rather than all the columns. By default Qlik Replicate include all columns in the task design. You may simply to remove some columns from the table transformation for example I'd like to remove the column "NOTES" from the replication:

john_wang_1-1709185798819.png

After the column "NOTES" is removed from the design, the table has 2 columns in target side.

Certainly in some scenarios you may want to add some additional columns eg the transaction datetime, and other computed columns etc. see User Guide Overview of the Expression Builder.

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Yadunandan
Support

Hello @MdFazil 

Yes it is possible, you need to select the tables which you require to replicate in the table selection window while setting up a task. please see selecting tables  for more information.

Regards,"
Yadunandan

MdFazil
Partner - Contributor III
Author

Hello @john_wang, thanks for the reply. 

Yes, this clarify my doubt

Regards
Fazil

john_wang
Support

Glad to hear that, Thank you for the support! @MdFazil 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
MdFazil
Partner - Contributor III
Author

Hello @Yadunandan , Thank you for the reply.

Thanks for sharing some documentation. I'll look into that for more details

Regards
Fazil