Overview

Each time you run analysis on a model, PhixFlow creates a new set of data in each table; see Table. A recordset is a collection of data in a table for a given period. 

Recordsets, and the data they contain, remain in the table until you archive the data (see Task) or manually remove it (see rolling back record sets below). 

If there is a problem during the analysis run, you may find that a recordset has incorrect or missing data, usually indicatd by indicated by a yellow highlight in the recordset list. To fix recordsets, you can undo the analysis by running rollback or if you fix the issue and re-run analysis PhixFlow will attempt to repair the recordset.

Learn More

• Managing Models and Data

Opening the Recordset List

1. To see a list of recordsets:
   1. in a model, right-click a table to display the pop-up popup toolbar,
   2. in the repository, right-click a table name to display the context menu,
   3. in the table properties, click the more menu
2. then click 

   Insert excerpt
   _recordsets_show _recordsets_show nopanel true

   .
3. The recordset list shows all recordsets for the table, as illustrated below:
4. To view the content of a recordset double click on any row.
5. Each time you run analysis on a table the new recordset details are added at the top of the list.

The Recordset List Details

The recordset list includes details about:

1. Run ID, a unique identifier for the analysis that has been run It can be used when roiling back.
2. From Date,
   
   1. For Transactional Tables this is when the analysis was started.
   2. For Variable Tables this is when the analysis last ran.
3. To Date, when analysis finished.
4. Created Date, the date the record set was created.
5. Size, the number of records in the recordset.
6. Status,
   1. OK, is a complete record set with no issues.
   2. Incomplete, is a recordset that is incomplete due to an error in analysis.
7. Owner, provides the name or the user, or system, that initiated the analysis.
8. Archive Time, when it was archived.
9. Parent, location of the recordset.
10. Cycle, list the cycle of the analysis run when run multiple times.  
11. Instance ID, an internal id for locating the recordset.

The toolbar has the standard icons and Image Modified Move Recordsets. 

Moving Recordsets

To move recordsets between tables:

1. Select one, several or all recordsets in the list.
2. Drag 

   Insert excerpt
   _recordset_move _recordset_move nopanel true

    over another table on the analysis model or into a recordset list. 
3. PhixFlow asks if you want to copy or move the data
4. Select an option. For more information see Copying or Moving Table Data.

Viewing Recordset Data

To view the recordset data, double-click on a recordset. PhixFlow opens the default view of the data that the recordset contains. If the recordset contains superseded records they will be included in this view, indicated by a grey background.

Rolling Back Recordsets

See Rollback Recordsets.

Context Menu

In the recordset list, right-click on a recordset to display the context menu. The options are:

• Show Log File: display the log file for the analysis run that generated this recordset.
• Rollback Recordset: rollback this recordset, and all recordsets that come after it; see Rollback Recordsets.
• Show Recordset Data: display a table showing the data in the recordset.
• Reprocess Recordset: this option is available for incomplete recordsets in an transactional table. Rerun the current recordset.

Learn More

• Managing Models and Data