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 schedule for automated collection. 

Manually Upload Solution

1. In the toolbar, find the Create section. Click on File, and drag Collector onto the canvas.
   1. Image RemovedImage Added
2. A properties window opens on the right, enter a Name.
3. Hover over your file collector and click the Upload Managed File button from the popup menu.
   1. Image RemovedImage Added
   2. Navigate to the Excel file you wish to import.
   3. Click Open.
   4. Click Upload Managed File.
      1. If the file has multiple tabs, select the required tab in the prompt and click confirm.
4. A file collector is created that will hold the imported data.
5. When you are ready to import the data hover over the table and click Run Analysis.
   1. Image RemovedImage Added
6. To view the data hover over the table and click View → Default View
   1. Image RemovedImage Added

Automated Solution

See Importing a Managed File.

Learn More

• File Collector 
• Understanding Displaying Data (Views)