Overview

Tasks are the data transformations offered by Mammoth. A Task adds a layer of change on top of the original Dataset. Each new Task then adds a new layer on the previous state, and so on.

A record of all Tasks is stored as a list in the Pipeline. Each Task in the Pipeline runs sequentially and can be paused by turning off auto-sync. (in the Sync Settings in the Preview Panel). You can partially re-run the Pipeline if any Task is edited or discarded.

pipeline example

Fig. 107 A Pipeline

Adding Tasks

A Task can be added using the Data Preparation menu. Clicking on a Task opens a Task Panel where you can provide the inputs for the Task, be that a condition, calculation, join, etc.(See Tasks for m ore information about Tasks.). Once a Task is added, all the data is refreshed to reflect the changes and a new entry for the Task is added to the Pipeline.

adding a Task

Fig. 108 Adding a Task

Editing Tasks

Any Task can be edited in the Pipeline by clicking on the Modify option in the menu at the top right corner of the Task.

Note

You will see a warning message when an edit affects other Tasks in the Pipeline. If you choose to proceed, the Pipeline will go into error and will need corrective action. The APPLY button is only enabled when the Task has valid inputs.

editing a Task

Fig. 109 Editing a Task

Deleting Tasks

Remove a Task by clicking the delete option in the menu at the top right corner of the Task. It will display a prompt for you to confirm because a deleted Task cannot be recovered.

Note

The system will also warn you if deleting a Task may affect other Tasks in the Pipeline. If you proceed, the Pipeline will go into error and you will need to take corrective action.

deleting a Task

Fig. 110 Deleting a Task

Errors in Pipeline

The Pipeline in a View can have Tasks that create new columns. These columns may be used in subsequent Tasks in the Pipeline. If your edit changes the column type or it is removed altogether, subsequent Tasks using these columns will go into error and the Pipeline will not work.

Also, a Dataset may change when a column is removed or its type is changed. Any Tasks using such columns in any View of the Dataset will then be in error.

Changes due to Errors in Pipeline

pipeline error

Fig. 111 When a Pipeline in a View is in error, the Task is highlighted with red borders. Also, the View tab and Pipeline icon will show a red dot and the data grid and actions like Explore columns, Alerts, and Column browser will be greyed out.

Data Library when Pipeline is in error

Fig. 112 In the Data Library, the View in error will display a red exclamation icon and the Open button in the Preview Panel for the broken View will turn red with a message saying: “This view has errors.”

Restrictions due to Errors in Pipeline

As shown above, in Fig. 111, Error(s) will disable various features for a specific View, such as:

  • Column browser, Metric Explore Panel, Explore Cards, Alerts, Export, CSV links.

  • Renaming, duplicating, or saving a View as a template.

  • All export Tasks, Crosstab, and Branch out to Dataset.

Fixing Errors in Pipeline

When an error occurs, you have two options - Fix or Delete:

  • Delete simply deletes the Task.

  • Fix opens the edit Task window for you to rectify the problems in the Task.

Fixing the error in Pipeline

Fig. 113 Fixing error in the Pipeline

Sometimes fixing errors in one Task may create a cascade of new errors elsewhere. If this feels messier, It may be wise to make a fresh start by using the “Discard Changes” option at the bottom of the Pipeline to return it to its original state.