\If you have loaded data into an ERD and wish to change the data types of any of the attributes you will first need to rollback the data in the table. If you wish to reimport the data and or import more data you will need to create an analysis model.
Rolling Back Data in an ERD
- Open the Properties of the table you want to clear.
- From the more menu, click Show StreamSets.
- Right-click and select Rollback Streamset.
- Tick Rollback all data
- Untick Keep Old Streamsets
- WARNING! If you do not want to clear all your data, see Rollback Recordsets for full details on what to do.
- IOf you are sure you want to clear all data, click Confirm
Reimport / Add More Data into an ERD
- First you will need to create an analysis model,
- Click Analysis from your application's home page.
- Click Add and follow the prompts.
- Click Calculate Table from the canvas toolbar, this will list all available tables in your application.
- Drag the table onto the canvas.
- Move your mouse over the Table, from the hover menu select the Show Inputs button (back arrow).
- This adds the File Collector used to import your file into PhixFlow.
- Move your mouse over the file collector, from the hover menu select File
- Select your file from the popup and click Open then Upload Managed File.
- Mouse over the Table again, from the hover menu select Run Analysis
- The file has been read into PhixFlow.
- see Viewing Data in a Table for information on viewing your new data.