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

...

Excerpt

Through the Import Data page, you can upload datasets or select datasets from sources that are stored on connected datastores. From the Library page, click Import Data.


Image RemovedImage Added

D caption
typefigure
Import Data page

...

You can select a single dataset or multiple datasets for import.

...

Edit settings

You can modify settings used during import for individual files. In the card for an individual dataset, click Edit Settings.

...

For more information, see Sanitize Column Names.


Selecting Column Headers: (file only) You can apply the column headers to your datasets during import. Select the required option from the drop-down list:

  • Infer Header: (default) When selected, the 
    D s webapp
     infers the header based on the data in the import. 
  • Use first row as header: When selected, the first row is used as the column headers.

  • No Header: When selected, the inference is ignored and column headers are defined using generic names with no headers.

If replacing a file: 

  • If you replace a dataset in a flow and select the Use first row as header option, then the existing header row labels are updated with the new headers.
  • Subsequent steps in a pre-existing recipe may be broken if the headers are changed by a replaced file.
Tip

Tip: After the dataset is imported, you can rename columns manually or using any row in the dataset. For more information, see Rename Columns.

4. Import selections

Single dataset

If you have selected a single dataset for import:

Tip

Tip: If present, you can click the Add to new flow checkbox, which adds the imported datasets to an Untitled flow. For more information, see Flow View Page.

  • Click Continue. The dataset is imported. 
  • A recipe is created for it, added to a new flow, and loaded in the Transformer page for wrangling. See Transformer Page.

...


If you have selected multiple datasets for import:

...

The datasets are imported and added to a new flow.

Info

NOTE: To rename this flow, click Untitled at the top of Flow View.

...

Tip

Tip: If present, you can click the Add to new flow checkbox, which adds the imported datasets to an Untitled flow. For more information, see Flow View Page.

  • To import the selected datasets, click Continue

    • To begin transforming one of these datasets in Flow View, select it. From its context menu, select Add new recipe. Select the recipe. In the context panel on the right, select Edit Recipe. See Transformer

    Page.For more information, see Flow View
  • To remove a dataset from import, click the X in the dataset card.