Loading data from files

There are two ways to load data from files into EasyMorph:
  • Load one or more files, create a separate table for each loaded file
  • Load multiple uniform files as a single table

Loading a file

The easiest way to load a file is to simply drag the file into EasyMorph. In this case EasyMorph automatically creates a new import transformation depending on the file extension. Extensions that are recognized automatically: xls, xlsx, txt, csv, psv, tsv, qvd, sas7bdat. You may need to adjust settings of the created import transformation in order to load the file correctly — e.g. choose a separator, or pick columns.

Another way is to create an import transformation explicitly. You can select appropriate import transformation from the Start screen, or by going to menu Main (or Design) and pressing "Insert table or chart" button.

Below is a list of available file import transformations in EasyMorph:

  • Import from delimited text file (e.g. CSV)
  • Import from Excel spreadsheet (.xls, .xlsx)
  • Import from XML (.xml)
  • Import from Qlik (.qvd)
  • Import from SAS (.sas7bdat)

Example: US Census 2012

Hint: To reduce clutter move tables to different tabs. To move a table to another tab create a new tab, then right-click the table tile bar and choose "Move to another tab", or press Ctrl+M.

To load a few files drag them one after another into EasyMorph (one at a time), or create a separate import transformation for each file. One import transformation creates one table. You can later use "Append" transformation to concatenate them into one table, if needed.

Loading multiple uniform files as one table

Loading multiple uniform files (files with same column set, e.g. daily extracts) as one table requires using iterations. Iterations is a somewhat advanced topic. It is explained later in this tutorial in chapter Loops and iterations.
Briefly, it works as follows:

  • Create a project (A) that loads one file; create a parameter
  • In Import transformation replace file name with a parameter; save the project
  • Create another project (B) with a list of files to load (you can use "List of files" transformation to create such list)
  • Use Iteration transformation in Iterate & Append mode to run project A for every file in the list

See example of loading multiple files : Iterations.zip (example #1)

In version 3.6 planned for release in June 2017 we will be introducing a way to load multiple uniform files without iterations.

Read next: Load data from database