- 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. For more information, see Import Excel Data.
- 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 filenaming pattern. For more information, see Create Dataset with Parametersfile 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.
- By default, the application applies a few steps to file-based imported datasets to attempt to organize them into tabular format and hides these steps from your recipe. As needed, you can disable these automated steps, so that the steps themselves appear in the Recipe panel. For more information, see Remove Initial Structure.
- If your file uses a different file encoding than the default encoding, you can change it for the file during the import process. For more information, see Change File Encoding.
When you are ready to complete the import process:
Tip: If present, you can click the Add to new flow checkbox, which adds the imported datasets to an
If you are importing a single file: click Import to load it into the Library page. Or, you can click Import & Wrangle to import the file, add it to a flow of the same nameclick Continue to load to add it to a new flow, create a recipe for the imported dataset, and begin editing that recipe in the . See Transformer pagePage.
- If you are importing multiple files: click Import Datasets to click Continue to load them into the Library page. Or, you can click the Add Datasets to Flow checkbox to select or create the flow to which to add these imported datasets. Click Import & Add to Flow. See Flow View Page.
- Your files are imported available as imported datasets.
For more information, see Import Data Page.
|D s also|