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 are file import transformations available in EasyMorph:
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.
To load several uniform files (e.g. files of one type with the same set of column headers) use the multuple load mode which is available in any file import transformation.
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 defined in two ways:
Loading multiple uniform files (files with same column set, e.g. daily extracts) as one table in versions prior to 3.6 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:
See example of loading multiple files : Iterations.zip (example #1)