...
- Permanently delete the generated Stream ReadAccountHistory
- Open the configuration form for the file collector by double-clicking the icon on your modelling pane
- Go to the Advanced tab
- In the field Excel Data Expression enter: "accountHistory!A1:F100"
- Press
- Apply
- Go to the File Columns tab
- Delete the attributes that have been automatically created (these reflect the data in the first sheet in the workbook)
- Move to the File Columns tab
- Press
- Create the file attributes automatically from the header row in the file
- Press
CenterView PhixFlow will read the file and work out the attributes that make up the file. You will see these attributes appear in the Attributes list
- In the banner of the File Collector details form, press
- Create a new Stream using the File Collector attributes - Have a look the attributes in the new stream – you can see that these have been derived from the columns in the file collector
- Save your changes
- Run analysis on the Stream and confirm that the data that has been read into CenterView PhixFlow is from the second tab in the spreadsheet