How to group data into json file

Anonymous — Sat, 16 Nov 2024 06:00:53 GMT

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

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.

Re: How to group data into json file

Anonymous — Mon, 20 May 2019 06:12:48 GMT

Hello,

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

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

Best regards

Sabrina