/
Importing Data From Excel
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 , and drag Files onto the canvas File Collector
- A opens on the right, enter a Name Properties tab
- Hover over your file collector on the canvas and click the button from the popup menu Upload File
- 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 is created that will hold the imported data File Collector
- When you are ready to import the data hover over the and click Table Run Analysis
- To view the data hover over the and click Table Show view
Automated Solution
Learn More
, multiple selections available,