Grouping Rule (grouping) β
Groups data by specified columns and applies sub-rules to each group.
| Field | Description | Required |
|---|---|---|
columns | Array of column names to group by | β Yes |
rules | Array of sub-rules to apply to each group | β Yes |
Example: β
json
{
"type": "grouping",
"columns": ["customer_id", "product_type"],
"rules": [
{"type": "trim_whitespace", "source_column": "description"}
]
}Behavior: Groups data by customer and product type, then applies whitespace trimming to each group.