Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
Introduction
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.
Manual Upload Solution
- In the toolbar, find the Create section. Click on File, and drag Collector onto the canvas.
- A properties window opens on the right, enter a Name.
- Hover over your file collector and click the Upload Managed File button from the popup menu.
- Navigate to the Excel file you wish to import.
- Click Open.
- Click Upload Managed 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 View → Default View