Use a Write (Value library) block as an interface between the Database and the Optimizer (Value library). Follow these steps:
- In a Write block, select the Database and table with the variables for the Optimizer.
- Drag the clone of the preview table from the Write block to the Optimizer once per variable in the Optimizer.
- Set the row and column in the Optimizer for the table. Remember that these are 0 based references (the first row and column are numbered 0).
When the Optimizer changes the variables, they will automatically be changed in the Database.