There are three ways to load data from local files into EasyMorph:
- Import one file at once
- Import multiple uniform files
- Load a list of files
Loading one file
To load a single file, press the "Add data" button, select "Import file" and choose the type of file you want to load.
Loading multiple files
To load multiple files, press the "Add data" button, select "Import multipe files" and choose the type of files you want to load.
After that in new dialog window browse to the folder which contains files you want to load; check the checkboxes near the files and press OK.
Hint: Also file/files can be imported by appropriated buttons on the start screen, in Workflow editor tab. In this case files will be opened in new created Project.
File formats
Below are the file formats supported in EasyMorph:
Description | Extensions |
---|---|
Delimited text file (e.g. CSV) | .csv, .psv, .tsv, .txt or other |
Text with fixed width columns | .txt or other |
Excel spreadsheets | .xls, .xlsx, .xlsm |
XML files | .xml |
Qlik QVD files | .qvd |
SAS data files | .sas7bdat |
SPSS/PSPP data files | .sav |
EasyMorph datasets | .dset |
SQLite data files* | .sqlite, .sqlite3 or other |
* To load from an SQLite data file, create a database connector first.
See Loading from databases for details.
Drag and drop
Alternatively, you can load a file by simply dragging it into EasyMorph. In this case, EasyMorph automatically creates a new import action depending on the file extension. Extensions that are recognized automatically: xls, xlsx, txt, csv, psv, tsv, qvd, sas7bdat, dset. You may need to adjust settings of the created import action in order to load the file correctly — e.g. choose a separator, or pick only particular columns.
Hint: When you load multiple files into multiple tables, it may clutter your workspace. To reduce clutter, move tables to different tabs (Groups). To move a table to another tab create a new tab (Group), then right-click the table's tile bar and choose "Move to group", or press Ctrl+M.
Loading multiple uniform files as one table
While it's always possible to concatenate multiple tables into one using the "Append" action, it may be inconvenient when many files have to be loaded. In this case, instead of appending tables explicitly, it is possible to load multiple files and automatically concatenate them into one table. The files must be uniform — e.g. they must be of the same type and have the same set of columns. To load several uniform files, use the multiple load mode which is available in any file import action.
In this mode, multiple files in a particular folder are loaded and automatically concatenated into one table in EasyMorph. The files to load can be specified in two ways:
- Explicitly select particular files to load.
- Select all files that match a search criterion such as search string, wildcard, or regular expression.
Hint: To quickly load multiple files from a folder, drag and drop the folder into EasyMorph. A necessary file import action will be created automatically. This will work even if the folder contains files of different types — EasyMorph will offer you to pick a file type to load.