# table sync with different columns

**URL:** https://forums.percona.com/t/table-sync-with-different-columns/6050
**Category:** Percona Toolkit
**Created:** [December 5, 2017, 7:31am UTC](https://forums.percona.com/t/table-sync-with-different-columns/6050 "2017-12-05T07:31:02Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Stef\_Coene](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@Stef\_Coene](https://forums.percona.com/u/Stef_Coene)
#### Post date: [December 5, 2017, 7:31am UTC](https://forums.percona.com/t/table-sync-with-different-columns/6050/1 "2017-12-05T07:31:02Z")

</div>

Hi,

I need to find a way to sync multiple remote tables into 1 local table.

The remote tables has 2 extra columns that do not need to be synced.  
The local table has 1 extra column. This extra column represent the ID of the remote table.

Is it possible to do this with pt-table-sync?

Stef

---

<div class="post-metadata">

### Author: ![carlos.salguero](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/carlos.salguero/32/20_2.png) [@carlos.salguero](https://forums.percona.com/u/carlos.salguero)
#### Post date: [December 6, 2017, 8:52am UTC](https://forums.percona.com/t/table-sync-with-different-columns/6050/2 "2017-12-06T08:52:35Z")

</div>

No. pt-table-sync cannot “merge” 2 tables into 1