topic Re: tWriteJSONField only outputs tree, how to pass other columns? in Talend Studio

tWriteJSONField only outputs tree, how to pass other columns?

hvanderborg — Sun, 11 Aug 2013 09:05:29 GMT

Hi,
When using tWriteJSONField it passes on the tree, but how can you pass on other columns in the flow to the next components?
Tried adding all columns to the schema of tWriteJSONField (Edit schema) but in output all are NULL except the field created with the json tree. Seems like a bug or could be a missing feature.
How can I pass on my data? Hope someone is willing to help out.
Thanks,
Henry

Re: tWriteJSONField only outputs tree, how to pass other columns?

Anonymous — Sat, 17 Aug 2013 15:13:21 GMT

Henry
Which component is the next component? Why you need to pass other column to the next component? Can you explain your request in detail?
Shong

Re: tWriteJSONField only outputs tree, how to pass other columns?

Anonymous — Wed, 04 Jun 2014 13:35:08 GMT

Same problem here. The next component is tFileOutputDelimited. Previous component is tFileInputXML and I just want to merge 3 columns into 1 JSON column and keep all others columns untouched. But they output with null values. Can you help me please ? Shall I split flows with tReplicate before and merge them after the JSON component ?

Re: tWriteJSONField only outputs tree, how to pass other columns?

Anonymous — Wed, 04 Jun 2014 18:14:11 GMT

Solution can be found here using this custom component : https://github.com/ijokarumawak/tRowToJSON