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

tWriteJSONField outputs tree, how to pass other columns?

idembel2 — Sat, 16 Nov 2024 00:01:04 GMT

Hi everybody,

I have an input file that contains 6 columns,

I used the first 5 columns in a component twritejsonField to get my json output tree; problem is that i need to pass also the sixth column like parameter in next component (tRestclient).

But i don't know how to pass at the same time my json output tree and the 6th column to my next component (tResClient)

Thank for help

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

Anonymous — Thu, 24 Jun 2021 04:30:30 GMT

Use a tFlowToIterate to iterate the input rows, add a tMap after tWriteJSonField and add a new column, set its value like:

(String)globalMap.get("row1.columnName")

the job design looks like:

tFileInputDelimited--main(row1)--tFlowToIterate--iterate--tFixedFlowInput--main--tWriteJSonField--tMap--out1-->tRestClient...

tFixedFlowInput: generate the current row only with 5 columns.

Regards

Shong

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

idembel2 — Thu, 24 Jun 2021 09:37:55 GMT

Hi Shong,

Thank you for your help, i test your idea and let you know.

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

idembel2 — Thu, 24 Jun 2021 13:53:31 GMT

I test it and it works

Thank you very much Shong