Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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