{{ transformations:ImportDatasetAction.png}}
====== 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**//||
|Load file<sup>*</sup>| Fully-qualified file name of the dataset (includes relative or absolute path).  |
|Password| Provide the password to open the dataset, if required.|
|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.|
|//**EasyMorph Server file settings**//||
|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<sup>*</sup>|Select the pre-configured connector to the EasyMorph Server.|
|Path<sup>*</sup>|Fully-qualified filename of the dataset.|
|Password| Provide the password to open the dataset, if required.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\

\\ 
=====Remarks=====
This action can import multiple files.  See [[import:fileimportmodes|Importing Multiple Files]] for more information.\\ 

\\ 
=====Community examples=====

  * [[https://community.easymorph.com/t//1769/1|How to do recursive loops in EasyMorph]] ([[https://community.easymorph.com/uploads/short-url/qM6kmqrDRWiEDJFljIa2u6QWre1.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Loop//; Action position: //4//)
  * [[https://community.easymorph.com/t//1854/2|Product of Rows in a Column
]] ([[https://community.easymorph.com/uploads/short-url/8o7F1FHzlEr0hUV2BgCLFNEMKqk.morph|Project]]; Module: //Multiply line//; Group: //Tab 1//; Table: //Imported table 1//; Action position: //1//)
  * [[https://community.easymorph.com/t//2185/4|Transform parsed JSON to right format
]] ([[https://community.easymorph.com/uploads/short-url/z1JsbbyueYletNwNg1VlSef2C4C.morph|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:exportdataset|Export dataset]]