Group By

Group By | Online Free Tool | Elysia Tools

Tool usage guide

Learn when to use this tool, what it supports, and how real users apply it.

Key facts

Category: Data Processing
Input types: textarea, select, text
Output type: text
Sample coverage: 4
API ready: Yes

Overview

The Group By tool allows you to organize complex JSON collections into structured groups based on a specific property or path, powered by the reliable lodash _.groupBy function.

When to use

When you need to categorize items in a large JSON array by a shared attribute.
When you want to transform a flat list of objects into a dictionary for faster lookups.
When preparing data for reports or UI components that require grouped data structures.

How it works

1Paste your JSON array or object into the Collection field.
2Select the Iteratee Type to determine how the grouping key is derived.
3Specify the property name or path if using the Property/Path mode.
4Run the tool to receive a new JSON object where keys represent the groups and values contain the associated items.

Use cases

Organizing user logs by status codes (e.g., 200, 404, 500).
Grouping product inventory lists by category or manufacturer.
Sorting transaction records by date or customer ID.

Examples

1. Categorizing Product Inventory

Background

An e-commerce manager has a flat list of products and needs to display them by category on a dashboard.

Problem

The raw data is a single array, making it difficult to render category-specific sections.

How to use

Input the product array, set Iteratee Type to 'Property/Path', and set Iteratee to 'category'.

Collection: [{"name":"Laptop","category":"Electronics"},{"name":"Shirt","category":"Apparel"},{"name":"Phone","category":"Electronics"}]

Outcome

A JSON object grouped by category, with 'Electronics' containing the laptop and phone, and 'Apparel' containing the shirt.

2. Grouping API Response Logs

Background

A developer is debugging server logs and needs to see all failed requests together.

Problem

The logs are mixed together, making it hard to identify patterns in error codes.

How to use

Input the log array, set Iteratee Type to 'Property/Path', and set Iteratee to 'status'.

Collection: [{"id":1,"status":200},{"id":2,"status":500},{"id":3,"status":200}]

FAQ

What input formats are supported?

The tool accepts standard JSON arrays or objects.

What is the difference between Identity and Property/Path?

Identity groups items by their own values, while Property/Path allows you to specify a key or nested path within each object to group by.

Does this tool modify my original data?

No, it processes your input and returns a new structured result without altering the original source.

Can I group by nested properties?

Yes, by selecting Property/Path and providing the dot-notation path to the nested key.

Is this tool based on a specific library?

Yes, it utilizes the industry-standard lodash _.groupBy function for consistent and accurate results.

What this tool helps you do

Run this tool

Inputs

Result

Examples that match this tool

Continue with connected tools and hubs

Inputs

Result

Learn when to use this tool, what it supports, and how real users apply it.

Key facts

Overview

When to use

How it works

Use cases

Examples

1. Categorizing Product Inventory

2. Grouping API Response Logs

FAQ

Grafana Advanced Application Samples

QR Code Samples

Postman Collections - API Testing

D3.js Data Visualization Samples

Count By

Find Key

Get Path

Index Of

JSON Interchange and Format Translation Tools

JSON Inspection, Diff, and Transformation Tools

JSON Schema, Mock Data, and API Fixture Generators

JSON Formatting, Diff, and Normalization Tools