# Transfer a colunm values from a table to another table

**URL:** <https://forum.inductiveautomation.com/t/transfer-a-colunm-values-from-a-table-to-another-table/79299>\
**Category:** Ignition\
**Tags:** ignition81, perspective, scripting, database\
**Created:** [September 18, 2023, 4:37pm UTC](https://forum.inductiveautomation.com/t/transfer-a-colunm-values-from-a-table-to-another-table/79299 "2023-09-18T16:37:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Leandro\_Garcia\_Carva](https://avatars.discourse-cdn.com/v4/letter/l/6f9a4e/32.png) [@Leandro\_Garcia\_Carva](https://forum.inductiveautomation.com/u/Leandro_Garcia_Carva)\
**Post date:** [September 18, 2023, 4:37pm UTC](https://forum.inductiveautomation.com/t/transfer-a-colunm-values-from-a-table-to-another-table/79299/1 "2023-09-18T16:37:22Z")

</div>

[Productivity Screen Concept v2.xlsx](https://forum.inductiveautomation.com/uploads/short-url/3wjOc6SQprexB9ocRWpyZhwaslD.xlsx) (14.4 KB)  
Hi,

I need to create three tables to Ignition perspective. This is the way it should work.

When I push the _Add Row Button 1_ it should send blue column values from the blue table in a blue column of the Master table.

When I push the _Add Row Button 2_ it should send green column values from the green table to a green column of the Master table.

I`m going to send you an xlsx file which contain those three tables.

Could you help me whith it? I have no Idea how to do this.

Regards,

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [September 18, 2023, 5:31pm UTC](https://forum.inductiveautomation.com/t/transfer-a-colunm-values-from-a-table-to-another-table/79299/2 "2023-09-18T17:31:41Z")

</div>

How are the blue and green tables stored now? If it's in a db table, you should be able to use a query with a join to get the data in a format you need.

---

<div class="post-metadata">

**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\
**Post date:** [September 19, 2023, 1:35am UTC](https://forum.inductiveautomation.com/t/transfer-a-colunm-values-from-a-table-to-another-table/79299/3 "2023-09-19T01:35:03Z")

</div>

So, you create three tables in your Database. Add the fields you need to each table. Create named queries, with parameters, to insert specific rows into the master table.