Aggregating cells
3 minute read
It is possible to execute Mongo DB aggregation pipelines in the Data Miner app. The output from the aggregations can be in two formats - CSV and JSON.
Note
|
CSV format is good for simple structures, while JSON can contain any structures. |
Create pipeline
-
Press the
Add stage
button.Figure 1. Add stage button -
The new stage is displayed.
Figure 2. New stage -
Press
Select stage
to see the list of available operators.Figure 3. Select stage operator -
Every operator has a prepared stage body, which can be left as it is or changed.
Figure 4. Stage bodyIf the stage body is valid, a partial result is visible on the side. The result depends on the stage it belongs to and all the stages before.
Figure 5. Stage body
Change the order of stages
Move up/down
buttons become visible if there is more than 1 stage.
Enable and disable stage
Stages can be enabled or disabled using the Enabled
button.
Preview is displayed only if the stage is enabled and correct.
-
To run only specific stages in the pipeline, press the
Enabled
button to enable the stage.
-
As the stage is disabled, there is no partial result.
Deactivated stages can still be edited, moved, or removed. All without influencing the pipeline.
New favorite Aggregations
Aggregation can be saved as a favorite one and loaded back later.
-
Press the
New favorite aggregation
button.Figure 8. New favorite aggregation button -
Pop up window asking about the name of the new favorite aggregation is displayed.
Figure 9. Add favorite aggregation -
Press the
Add
button to save aggregation as a favorite.Figure 10. Loaded favorite aggregation
Save favorite aggregation
-
Press the
Save
button to save changes in the aggregation.Figure 11. Save aggregation button
Load favorite aggregation
-
Press the name of the selected favorite aggregation to see a list of all saved favorite aggregations.
Figure 12. List of favorite aggregations -
Select aggregation to load.
Import aggregation
-
Press the
Import pipeline
button to import aggregation.Figure 13. Import pipeline button -
The
Aggregation import
window is opened, add inside the aggregation to upload.Figure 14. Aggregation import window -
Press the
Ok
button to load aggregation.
Export aggregation
-
To export aggregation press the
Export aggregation
button.Figure 15. Export aggregation button -
The
Aggregation export
window is opened, with aggregation in text form.Figure 16. Aggregation export window
Run aggregation
-
Press the
Run aggregation
button.Figure 17. Run the aggregation button -
Select output format.
Figure 18. Output format options -
The window with the result is displayed. Press the
Download
button to download the result.