transformations:importdataset
Table of Contents
IMPORT DATASET (.dset)
Category: Import / File
Description
This action imports a dataset (tabular data) from a file in the native EasyMorph format (.dset). This format allows very fast loading data into EasyMorph as there is no data conversion.
One .dset file contains one dataset.
Action settings
Setting | Description |
---|---|
Import from | Select whether the .dset file is a Local file (on your system) or stored on an EasyMorph Server. |
Local file settings
Setting | Description |
---|---|
Load file* | Fully-qualified file name of the dataset (includes relative or absolute path). |
Password | Provide the password to open the dataset, if required. |
Import | Choose whether to import Data, Data and metadata, or just Metadata. |
Load all columns | Select if all columns are to be loaded. |
Load only selected columns | Select if only select columns are to be loaded. A drop-list will appear to select the columns you wish to import. |
Import metadata | Choose whether to import file metadata and/or custom properties. Options: Import file metadata and Import custom properties. |
* Setting can be specified using a parameter.
EasyMorph Server file settings
Setting | Description |
---|---|
Link to Server | Select to use the pre-configured link to an EasyMorph Server. (Use the Start screen to configure the Server Link if you haven't already done so. |
Connector* | Select the pre-configured connector to the EasyMorph Server. |
Path* | Fully-qualified filename of the dataset. |
Password | Provide the password to open the dataset, if required. |
Import | Choose whether to import Data, Data and metadata, or just Metadata. |
Import metadata | Choose whether to import file metadata and/or custom properties. Options: Import file metadata and Import custom properties. |
* Setting can be specified using a parameter.
Remarks
This action can import multiple files. See Importing Multiple Files for more information.
Community examples
- How to do recursive loops in EasyMorph (Project; Module: Main; Group: Tab 1; Table: Loop; Action position: 4)
- Product of Rows in a Column (Project; Module: Multiply line; Group: Tab 1; Table: Imported table 1; Action position: 1)
- Transform parsed JSON to right format (Project; Module: Main; Group: Group 1; Table: Imported table 1.dset; Action position: 1)
Shortcuts
Fast ways to create the action:
- Press the "Add data" menu button. Pick "Import file" or "Import multiple files".
- Drag an EasyMorph dataset file into the application window. Supported file extensions: .dset
- Drag a folder with EasyMorph dataset files into the application window.
See also
transformations/importdataset.txt · Last modified: 2024/08/14 00:34 by craigt