Good morning community,
OK. So here is the ask and if you help me, I will buy you a beer.
Suppose I have two tables: Table_1 and Table_2. In Table_1 I have one field named KPI holding three records:
In Table_2 I have three field names
I need to change Table _2 field names:
KPI_1 becomes Health
KPI_2 becomes Safety
KPI_3 becomes Environment
Alternatively, Table_2 could be created based on the number and field names of the fields could be a function of the number of records in Table_1.
Help is most appreciated.