Overview

If you have two tables where one was originally a copy of the other, you can:

• Copy all or some recordsets between the table
• Move all recordsets between the tables,

Solution

You can only move recordsets between table copies because PhixFlow matches the internal field names of the attributes to connect the data to the target table. A different table will not have the same internal field name for the attributes.

Use the recordset list to copy or move a recordset to another table which must be empty. For details of the recordset list, see Managing Recordsets.

To copy or move all recordsetst recordsets to the empty copied table:

1. In the recordset list, drag the Image Removed Image Added icon to Move Recordsets onto a table. 
2. In the pop-up popup window, select either Copy or Move.

To copy some some recordsets:

1. In the recordsets list, select some recordsets.
2. Drag the recordses the recordsets onto the copied table.
   You cannot move a selection of recordsets to another table.

PhixFlow warns you if copying or moving the data may remove data. This can occur if the attribute does not exist on the target table. 

Use the move option when you have a very large set of data that needs to be transferred to the target table, and:

• either the PhixFlow database has limites limited space
• or the copy will take a long time.

PhixFlow creates log entries for the move or copy operation in the System Console.

More Information

• Table
• Copying Models and Modelling ObjectsConfiguration
• Managing Recordsets
• System Console

For links to all pages in this topic, seesee Managing Models and Data