topic Re: How to group data into json file in Data Quality

How to group data into json file

Anonymous — Sat, 16 Nov 2024 06:00:55 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

akumar2301 — Wed, 24 Apr 2019 11:22:21 GMT

you have 1st sort the input with Brand Name

then tWritetoJSON

Output

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

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

Anonymous — Wed, 24 Apr 2019 11:42:34 GMT

i get just one element per table, this is the result obtained:

{

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

{Brand:"Toyota", Produit:"A"},

{Brand:"Toyota", Produit:"B"},

{Brand:"Toyota", Produit:"D"}

}

akumar2301 — Wed, 24 Apr 2019 12:20:58 GMT

Anonymous — Wed, 24 Apr 2019 14:01:46 GMT

Does not work

akumar2301 — Thu, 25 Apr 2019 09:30:19 GMT

Hello

{

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

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

}

is not correct json . check on https://jsonlint.com/

it should be like this :

{ "Data" :

[

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

]

}

Let me know your opinion.