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 for Batch Processing Data.

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.

1. Open the properties of the table you want to clear.
   For example, in the ERD, click on the table.
2. In the table properties toolbar, click  More Options to open the menu.
3. Select  Show Recordsets. PhixFlow opens a window listing all the recordsets.
4. Right-click on the first run that you want to roll back and select  Rollback Recordset.
5. PhixFlow opens the Rollback window.
   
   
   
   • Select Rollback all data.
   • Untick Keep Old Streamsets
     
     
6. 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:

1. In your application Home page, click Analysis.
2. Click   Add New. PhixFlow guides you through the process of creating and naming an analysis model.
3. In the model toolbar, click  Table to list the tables in your application.
4. Drag a table onto the canvas.
5. Mouse-over the table to display the popup toolbar. Click  Show Inputs.
6. PhixFlow adds a  File Collector to the model.
7. Mouse-over the file collector to display the popup toolbar. Click  File.
8. PhixFlow opens file browser window. Navigate to your file and click Open then  Upload File.
9. Mouse-over the table again and select  Run Analysis.
10. 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.