topic Re: tFileOutput not recognizing global variable in Talend Studio

tFileOutput not recognizing global variable

bob_lemley — Fri, 15 Nov 2024 21:20:08 GMT

I have a job that does this tDBInput --> TWriteJSONField --> tJavaRow --> tFileOutputDelimited --> tJavaRow.

I the first tJavaRow I set a global variable for the file name. I also print out the variable so I can confirm it is correct.

I also have a print line in the second tJavaRow that again prints out the variable so I can confirm it is still set.

But when I use the global variable in the tFileOutputDelimited it comes across as null. If I set the global variable to a default value that default value is used in the tFileOutputDelimited filename so I know it can read the variable.

Is there a reason the tFileOutputDelimited cannot see the global variable value when it is changed?

It may be a logic thing with Talend I am not understanding. I asked Talend support and they sent me the canned response on context variables. I tried using a context variable but got the same results.

Re: tFileOutput not recognizing global variable

Anonymous — Sat, 14 Oct 2023 17:56:19 GMT

Please read this documentation page to learn the code generated mode. In this case, tFileOutputDelimited is initialized before tJavaRow, so change the job design as below, tFileOutputDelimited will have the value of global variable.

tDBInput --> TWriteJSONField --> tJavaRow -->tFlowToIterate--iterate--tFixedFlowInput--main--> tFileOutputDelimited -->

Regards

Shong

Re: tFileOutput not recognizing global variable

bob_lemley — Wed, 18 Oct 2023 15:48:31 GMT

Thank you, this worked for me. And thanks for the link, it had some very useful information.