Transfer a colunm values from a table to another table

Ignition
, , ,
1

Productivity Screen Concept v2.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,

2

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.

3

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.