topic Re: tWriteJSONField how to all in one datas in Talend Studio

tWriteJSONField how to all in one datas

Anonymous — Wed, 25 Oct 2017 16:03:58 GMT

Hi guys,

I'm trying to do exactly the same thing as the option "all-in-one" on tXMLMap for document (xml) response but on the component tWriteJSONField, with JSON format.

My purpose is to groupe all objects JSON into one row and not into the same number of objects.

Please, it's being a long time now that i cant figure it out.

Matthieu

Re: tWriteJSONField how to all in one datas

Anonymous — Wed, 25 Oct 2017 16:14:31 GMT

Hi
Add a new column and set a constant before tWriteJSONField, this column will be the group element on tWriteJSONField component.

Regards
Shong

Re: tWriteJSONField how to all in one datas

Anonymous — Wed, 25 Oct 2017 18:01:31 GMT

Hi Shong,

You can't imagine how much you helped me !

Thanks this works easily great. I added a column in the tMap just before the tWriteJSONField, with a constant value ( "test" )and then added to the group by section of the tWriteJSONField as input.

Thanks !

Matthieu DELMAS

Re: tWriteJSONField how to all in one datas

Anonymous — Thu, 26 Oct 2017 05:23:10 GMT

Great, thanks for your positive feedback!

Re: tWriteJSONField how to all in one datas

Anonymous — Sat, 03 Nov 2018 17:35:25 GMT

I want to add my thanks here too because I spent over a day trying to solve this without having to resort to custom Java code.

To be honest, the tWriteJSONField component should not force you to do this. Many of us want to do exactly the same thing, take a lot of rows from an output and stuff them into a JSON array, without regard for grouping. I tried a large number of permutations of JSON tree configurations, and none worked.

Re: tWriteJSONField how to all in one datas

EV89 — Tue, 12 Jul 2022 10:02:31 GMT

A question @Shicong Hong , but if i need only the grouped column how removed the fixed column after have grouped?

thanks for your help