Once you loaded data into EasyMorph (and profiled it), you can start transforming it.
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 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 the "Remove columns" actions 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" 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 right-click menu EasyMorph automatically creates the "Aggregate" actions with selected columns but without grouping. To specify grouping you will need to additionally edit properties of the "Aggregate" actions in the side bar.
The full list of available actions with examples is available in the web-help. See Help: actions.
There is a number of operations that can be performed with actions in a project: