Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
nameanalysis
nopaneltrue

This page is for data modellers who want to import data from an Excel spreadsheet.

Solution

  1. In the toolbar, find the Create section. Click on File, and drag Collector onto the canvas.
    1. Image 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 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 File Collector and click Run Analysis.
    1. Image Added
  6. To view the data hover over the File Collector and click View → Default View
    1. Image Added


Learn More