Transforming data

Once you loaded data into EasyMorph (and profiled it), you can start transforming it.

Adding actions

Throughout the tutorial, terms transformation and action will be used interchangeably. Actions (transformations) can be added (applied) to tables in various ways:

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

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

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

Note that in some cases automatically created actions might have incomplete properties. For instance when you aggregate data using the column context menu EasyMorph automatically creates the "Aggregate" action and tries to guess anticipated aggregated functions and grouping. To change the aggregation function and grouping you may need to additionally edit properties of the "Aggregate" action in the side bar.

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

Editing action chains

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

  • Drag actions inside a table to reorder them
  • Drag actions between tables to move a action from one table to another
  • Drag a action on the gray workspace to remove it
  • Press Ctrl key and drag a action to copy it
  • Right-click a action and choose Copy to copy it to another table or even to another project
  • Right-click a action and choose Split here to split a action 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 actions from a derived table (opposite operation to the one above)
  • Right-click a action 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 action, or right-click it and choose Calculate to calculate all actions up to the clicked actions, but not further

Read next: Filtering data