Transfer a colunm values from a table to another table

Productivity Screen Concept v2.xlsx (14.4 KB)

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.


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.

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.