Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

  • From the menubar, click Library for Data.
  • In the Library for Data page, click Import Data.
  • From the left sidebar in the Import Data page, select the connection where your data is located.
    • You must have read permissions on any directory and file that you wish to import.
    • Upload: Navigate your local desktop to select the file or files that you wish to upload.

      Tip

      Tip: You can select multiple files in the same directory for uploading at the same time.

    • File-based datastore: If you are uploading from a file-based backend datastore, navigate the available directories to locate your file.
      • Microsoft Excel: If you are importing an Excel file that contains multiple worksheets, you must select the worksheets to include as part of your import. 
      • Dataset with Parameters: If you are importing multiple files with similar filenames, you can import them as part of the same dataset using parameters or variables. In this manner, you create a single imported dataset, which automatically includes any new files that appear in the directory and that follow the same file naming pattern.

  • Some aspects of the import process can be modified. In the right panel, click Edit Settings for a file that you have imported.
    • Detect structure: By default, the application attempts to detect the file structure to convert it into a tabular format. Disable this setting only if you are experiencing issues with automated detection. 
    • If your file uses a different file encoding than the default encoding, you can change it for the file during the import process.
  • When you are ready to complete the import process:.

    Tip

    Tip: If present, you can click the Add to new flow checkbox, which adds the imported datasets to an Untitled flowa new flow.

  • Your files are available as imported datasets.

...