Transforming data

Once you loaded data into EasyMorph you can start transforming it.

Adding transformations

Transformations can be added (applied) to tables in various ways:

The basic way, which can be used for all transformations, is to click "Add transformation" in menu Main to get the list of available transformations, and then drag needed transformation from the list (in the sidebar) right onto a table. You can insert transformations at the end of the transformation chain, or between existing transformations.

Another way to transform data is to use context menu commands. For instance, when you click the "hamburger" icon on a column header (or right-click the header) and choose Remove column EasyMorph automatically creates "Remove columns" transformation with current column selected. You can apply the commands from the right-click menu to multiple columns. To select multiple columns Ctrl+click their headers.

You can also use the cell context menu to automatically create "Filter", "Clean up" and "Trim" transformations. Right-click a cell and choose a command.

Note that in some cases automatically created transformations might have incomplete properties. For instance when you aggregate data using the column right-click menu EasyMorph automatically creates "Aggregate" transformation with selected columns but without grouping. To specify grouping you will need to additionally edit properties of the "Aggregate" transformation in the side bar.

The full list of available transformations with examples is available in the web-help. See Help: transformations.

Editing transformation chains

There is a number of operations that can be performed with transformations in a project:

  • Drag transformations inside a table to reorder them
  • Drag transformations between tables to move a transformation from one table to another
  • Drag a transformation on the gray workspace to remove it
  • Press Ctrl key and drag a transformation to copy it
  • Right-click a transformation and choose Copy to copy it to another table or even to another project
  • Right-click a transformation and choose Split here to split a transformation chain and move the rest of the chain to a new derived table
  • Right-click a table and choose Merge derived table for merging all transformations from a derived table (opposite operation to the one above)
  • Right-click a transformation and choose Discard results to discard it's current result and force recalculation (if Auto-run is on)
  • When Auto-run is off — Ctrl + click a transformation, or right-click it and choose Calculate to calculate all transformations up to the clicked transformations, but not further

Read next: Filtering data