This page is for data modellers who want to view and manage data in tables.

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 run an archive task; see Task. If there is a problem during the analysis run, you may find that a recordset has incorrect or missing data. To fix recordsets, you can undo the analysis by running rollback; see Rollback Window.

Opening the Reocrdset List

To see a list of recordsets:

• either in a model, right-click a table to display the pop-up toolbar
• or in the repository, right-click a table name to display the context menu

then click 

The recordset list shows all recordsets for this table, for example: 

Each time you run analysis on a table, details of the new recordset are added at the top of the list.

Using the Recordset List

The recordset list includes details about when the recordset was created, its Run ID and its Size, which is the number of records it contains. 

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

To move recordsets to another table:

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

   Insert excerpt
   _recordset_move _recordset_move nopanel true

    to another table icon or recordset list. 
3. PhixFlow asks if you want to copy or move the data; see Copying or Moving Stream Data. Select an option.

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 of the recordset data.

Rolling Back Recordsets

See Rollback WindowFor non-transactional tables, which have a Period of Daily, Monthly or Variable, you can back-out the changes to data caused by an analysis run. This resets the data to a previous recordset; see Rollback Window.

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 Window.
• 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.