Group JSON by key value

Anonymous — Sat, 16 Nov 2024 02:38:24 GMT

Hey

I'm have a CSV-File as a datasource.

The datasource could look like this.

Brand - Model - HP - Seats

BMW,120,190,4

Audi,A6, 130,4

BMW,M4,400,4

Mercedes, A160, 120,3

Smart, ForToo,45,2

Mercedes, CLA45, 421, 4

I want to export my CSV-Data to a JSON-File that looks like this

[{"brand":"BMW","cars":[{"model":"120","hp":"190","seats":"4"},{"model":"M4","hp":"400","seats":"4"}]},{"brand":"Audi","cars":[{"model":"A6","hp":"130","seats":"4"}]},{"brand":"mercedes","cars":[{"model":"A160","hp":"120","seats":"3"},{"model":"CLA45","hp":"421","seats":"4"}]},{"brand":"smart","cars":[{"model":"ForToo","hp":"45","seats":"2"}]}]

How can i group by the key "brand"?

Is Talend able to do this?

Thank you in advance

topic Group JSON by key value in Talend Studio

Group JSON by key value