Page tree

 

Support | BlogContact Us | 844.332.2821

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

In addition to CSV and other formats, the 

D s webapp
rtrue
 can directly import Microsoft® Excel® workbooks. When the workbook is uploaded, you can select one or more of the worksheets to become separate datasets or to combine them into a single dataset. 

Steps:

  1. In the application toolbar, click Datasets
  2. In the Datasets page, click Import Data to select and upload your Excel workbook as an imported dataset. See Import Dataset Page.

    D caption
    typefigure
    Upload Excel workbook

    Tip

    Tip: If you experience issues uploading XLS/XLSX files that are larger than 35MB, you can convert the files to CSV files and then upload them.

  3. To add datasets: 
    1. Create one dataset with all workbooks: Click the Plus () icon next to the top-level item (PointOfSaleData in the above image).
    2. Create individual datasets: Click the Plus () icon next to each item you want to add as a separate dataset. The item is added to the right panel.
      1. To inspect the data in a worksheet, hover over it and then click the Eye () icon.
      2. You can always combine datasets together later using a union operation. 
  4. After your datasets have been added, you can edit the name and description information for each in the right navigation panel.
  5. Optionally, you can assign the new dataset(s) to an existing flow or create a new one to contain them.