Overview

If you have loaded data into an ERD and want to change the data or any of the attribute data types, first roll back the data in the table. To reimport the data or import different data, use an analysis model; see Analysis Models.

Rolling Back Data in an ERD

The following instructions explain how to roll back all the data in a table, so that you can change an attribute's data type.

If you want to clear some but not all data, see Rollback Recordsets for what to do.

Video

Instructions

Open the properties of the table you want to clear.
For example, in the ERD, click on the table.
In the table properties toolbar, click More Options to open the menu.
Select Show Recordsets. PhixFlow opens a window listing all the recordsets.
Right-click on the first run that you want to roll back and select Rollback Recordset.
PhixFlow opens the Rollback window.
- Select Rollback all data.
- Untick Keep Old Recordsets
If you are sure you want to clear all data, click Confirm.

Reimport or Add More Data

To import data to PhixFlow, create an analysis model:

In your application Home page, click Analysis.
Click Add New. PhixFlow guides you through the process of creating and naming an analysis model.
In the model toolbar, click Table to list the tables in your application.
Drag a table onto the canvas.
Mouse-over the table to display the popup toolbar. Click Show Inputs.
PhixFlow adds a File Collector to the model.
Mouse-over the file collector to display the popup toolbar. Click File.
PhixFlow opens file browser window. Navigate to your file and click Open then Upload File.
Mouse-over the table again and select Run Analysis.
PhixFlow runs the analysis model to load the file into the table. Check that the data has loaded correctly; see Viewing Data in a Table.

Browser not supported