Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
This page is for data modellers who want to import data from an Excel spreadsheet.
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 dragInsert excerpt _files _files nopanel true
onto the canvasInsert excerpt _file_collector _file_collector nopanel true - A
opens on the right, enter a NameInsert excerpt _property_tabs _property_tabs nopanel true - Hover over your file collector on the canvas and click the
button from the popup menuInsert excerpt _upload_file _upload_file nopanel true - 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 dataInsert excerpt _file_collector _file_collector nopanel true - When you are ready to import the data hover over the
and clickInsert excerpt _tables _tables nopanel true Insert excerpt _run_analysis _run_analysis nopanel true - To view the data hover over the
and clickInsert excerpt _tables _tables nopanel true Insert excerpt _view_show _view_show nopanel true