Aggregating Columns

The Aggregations function allows you to group selected columns and return the minimum or maximum value, the count of values, or unique values, the sum, or even the average of these groups. These values can either be displayed in a new column or overwriting an existing column.

Note: In order to perform Aggregations you should already have imported a data source into your Y42 Platform.


Adding the Aggregations Node to your Model

  1. In the Model tab, click Add... Name your new data model and choose a privacy level.
  2. Create at least one input table by dragging and dropping the Input field into your data model structure.

    Aggregations.png

  3. Choose a data table by clicking on the new Aggregations node, then click Apply.
  4. Drag and drop an Aggregations node close to the Input field.


Setting up Your Aggregations Node

  1. Click on the Aggregation node to apply the node settings.

    Agg.png

  2. First, select the columns you want to Group by.
  3. In the Target Column box, put a new column name if you want these values to appear in a new column or choose an existing column to overwrite it.
  4. Then, choose the column you want to aggregate (according to the selected Group By above) in the Source Column menu.
  5. Finally, choose the function you want to apply to the selected column. You can choose the minimum (MIN), maximum (MAX), the number of values (COUNT), sum (SUM), average (AVG) of your grouped column, Count Distinct or STDDEV. 
  6. You can add additional aggregations by clicking the blue + Apply more conditions.
  7. When you're done, click Save.

Once you're done aggregating columns within your model, you can either perform further transformations or, if you want to export the new data table, click Commit Model.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.