Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Group JSON by key value

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 0683p000009MACn.png

 

 

 

 

Labels (5)
0 Replies