---
title: Transform Group By
description: Similar to a groupby but returns a column to original dataset.
---

[Back to home](https://www.flow-wizard.com/knowledge)

- [ Analytical 
  
  ](https://www.flow-wizard.com/knowledge/analytical)
- [ Arithmetic 
  
  ](https://www.flow-wizard.com/knowledge/arithmetic)
- [ Data Prep 
  
  ](https://www.flow-wizard.com/knowledge/data-prep)
- [ Logical 
  
  ](https://www.flow-wizard.com/knowledge/logical)
- [ Charting Functions 
  
  ](https://www.flow-wizard.com/knowledge/charting-functions)
- [ Date Time 
  
  ](https://www.flow-wizard.com/knowledge/date-time)

# Transform Group By

## Similar to a groupby but returns a column to original dataset.

***Function:***

TransformGroupBy(table = *string*, value = *string*, cols =* list*, method = *drop down, new_col = string*)

 

***Parameters:***

*Table:* Table name on which to perform function

*Value:* Column with Values you wish to evaluate

*Columns to Group:* Columns that you wish to Group

*Method:* How to aggregate the data (sum, count, mean, min, max, median)

*New Column Name:* Name for new grouped table

 

***Examples:***

TransformGroupBy(table = Budget, value = Amount, cols =* *[geo, business_unit], method = sum*,  new_col = *Budget_Grouped)