Inc.5000 Companies 2014

This example is based on Inc.5000 Companies data as of 2014. It's a simple project that loads 2 tables from a local database (comes with the example) and a text file, merges them, calculates new column, aggregates data, and exports the result into an Excel report. The example demonstrates basic transformations, visual database query, project parameters, expressions, export to file.

Summary

  • Source data: 1 SQLite database (5000 rows), 1 CSV file
  • Transformations: 11
  • Export: 1 spreadsheet
  • Full run time*: less than 1 second
  • Designed for EasyMorph v3.8 or above

Inc.500 Companies example description (PDF)

Download

US Census 2012 (with Tableau workbook)

This project transforms data from the US census of 2012. It loads data from a 100MB text file, performs lookups using 3 external tables, filtering and aggregating, and then exports the final result into a Tableau Data Extract.

The example also includes a Tableau workbook with dashboard built using the TDE file generated in EasyMorph.

Summary

  • Source data: 4 text files, 450'000 rows (10MB zipped)
  • Transformations: 24
  • Export: 1 Tableau Data Extract
  • Full run time*: 15 seconds
  • Designed for EasyMorph v2.8 or above
Download

Formula 1 (querying a database)

This example shows how to load data from a database using a parametrized query. A sample tiny SQLite database is included so that no additional software installation required — the example works out of the box.

Summary

  • 1 database (included)
  • 1 text file
  • Full run time*: less than 1 second
  • Designed for EasyMorph v3.1 or above
Download

QlikView

This example shows how a data transformation logic can be designed in EasyMorph and then integrated with QlikView (or Qlik Sense). This allows users to see and modify transformation logic in a visual way, without dealing with the loading script. The example also demonstrates QVD file generation by EasyMorph and a way to iterate (process) a list of files.

In order to use this example you will need a trial license key. Download trial key.

Summary

  • Source data: 3 text files
  • Export: 1 QVD file
  • 1 QlikView application
  • 2 EasyMorph projects
  • Full run time*: 1-2 seconds
  • Designed for EasyMorph v2.8 or above
Download

Data normalization

This example demonstrates extracting dimensions and partial normalization of a denormalized dataset. It loads Inc5000 Companies data, creates a new table with a list of states and their primary keys, and finally replaces states in the main dataset with their respective keys. The example is a good demonstration of use of derived tables in EasyMorph.

Summary

  • Source data: 1 text file, 5000 rows
  • Transformations: 9
  • Full run time*: less than 1 second
  • Designed for EasyMorph v3.1 or above
Download

Character count (with parameters)

A small project that demonstrates the use of parameters in EasyMorph: transformation properties (e.g. file names) as parameters, calculated parameters, parameters in expressions.

The project loads a text file (specified by a project parameter) and then automatically counts the number of characters in its first N lines, where N is also a parameter. You can re-run the project with different text files and different N.

Summary

  • 3 parameters
  • 9 transformations
  • Full run time: depends on selected text file
Download

Iterations

Examples of various use cases for iterations in EasyMorph. Iterations is a powerful feature that allows arranging loops, processing lists of files, running projects for a range of dates, and re-using logic between different projects.

Designed for EasyMorph v3.0 or above.

Examples

  • Example 1 – load multiple files
  • Example 2 – split one file into many files
  • Example 3 – batch processing of several files
  • Example 4 – iterate and append data into one table
  • Example 5 – iterate another table (requires ver.3.1 or above)
Download

Email sendout

An advanced example that demonstrates sending customized database extracts to multiple recipients. The project imports a list of recipients from an Excel file and iterates across the list:

For each recipient on the list it pulls from a database a list of companies in the recipient's state. Then it sends the list to the recipient as an email attachment. The email's subject and text are customized for the recipient. If the list is empty, the project sends alternative email saying that no companies found for the specified state.

Summary

  • Source data: 1 SQLite database, 1 Excel spreadsheet.
  • One main project and one iterated sub-project.
  • 9 transformations in total.
  • Conditional IF/THEN workflow.
  • Designed for EasyMorph v3.7.1 or above.
Download

Income Statement

This example demonstrates how data transformation and simple reporting can be done using only EasyMorph and Excel.

The project extracts data from a complex Excel spreadsheet with income statement of a real public company, and then exports the data into an Excel report with a pivot table and a chart. You can modify the project, run it and see how the Excel report updates automatically when it's re-opened.

Summary

  • Source data: Excel spreadsheet and a mapping file
  • Target: another Excel spreadsheet
  • Full run time*: less than 1 second
  • Designed for EasyMorph v3.1 or above
Download

Computers

Experience a bit of nostalgia (or amusement, depending on your age) looking at typical computer specs of 1993-1995 and learn a few advanced techniques in EasyMorph — use of derived tables, self-join and referencing data from previous row.

Summary

  • Source data: 1 text file, 6'200 rows
  • Transformations: 30
  • Full run time*: less than 1 second
  • Designed for EasyMorph v3.1 or above
Download

* Run time was estimated on a laptop with Pentium i5 CPU and 16GB RAM.