...
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. |
D caption | ||
---|---|---|
| ||
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
infers the header based on the data in the import.D s webapp 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 |
- 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 |
...
Tip |
---|
Tip: If present, you can click the Add to new flow checkbox, which adds the imported datasets to an |
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.
- To remove a dataset from import, click the X in the dataset card.