How to group data into json file

[Anonymous]

I have data that i want to group based on a field , and the other fields into arrays. exemple this table:

Produit	Brand
A	Toyota
B	Toyota
C	Renault
D	Toyota

I want in the result a json file like that:

{

  {Brand:"Toyota", Produit:["A","B","D"]},

  {Brand:"Renault", Produit:["C"]}

}

Could some one help me please.

[Anonymous]

Hello,

Please have a look at this component:TalendHelpCenter:tWriteJSONField.

Let us know if it is what you are looking for.

Best regards

Sabrina