How to group repeating sections in JSON

Problem

In JSON, a section is repeated across multiple objects. You need to leave one object per section and collect the values ​​in an array.

Short answer

Use a JSON editor: select the desired node, set transformations and upload the result to the target structure.

Sample task

The data below is educational. They show the conversion form, not the users' actual files.

It was

[
  { "section": "Section A", "value": "Value 1" },
  { "section": "Section A", "value": "Value 2" },
  { "section": "Section B", "value": "Value 3" }
]

It became

[
  { "section": "Section A", "values": ["Value 1", "Value 2"] },
  { "section": "Section B", "values": ["Value 3"] }
]

How to set up

1. Upload your file and go to the JSON editor.
2. In the editor, find the desired value or node and click on it to open the settings window.
3. In the block "Transformations" add rules for selecting, renaming, or assembling values.
4. If some records need to be excluded, use a block "Unloading conditions".
5. Save the settings and download the result in the target format.