Importing Data From Excel
Overview
PhixFlow can import Excel files, including csv, manually uploaded by a user or collect files from a directory. The following setup illustrates the automated configuration for manually uploaded files. To collect files from a specific location see, Importing a Managed File. The latter can be scheduled for automated collection.
Manually Upload Solution
- In the toolbar, hover over Files, and drag File Collector onto the canvas
- A Properties tab opens on the right, enter a Name
- Hover over your file collector on the canvas and click the Upload File button from the popup menu
- Navigate to the Excel file you wish to import
- Click Open
- Click Upload File
- If the file has multiple tabs, select the required tab in the prompt and click Confirm
- A File Collector is created that will hold the imported data
- When you are ready to import the data hover over the Table and click Run Analysis
- To view the data hover over the Table and click Show view