topic Re: Can not call a dynamic global variable in another subjob. in Talend Studio

Can not call a dynamic global variable in another subjob.

AnnaSchmd — Fri, 15 Nov 2024 21:17:12 GMT

I have this job design:

in tSetGlobalVar_1:

==> Depending on the value of the Month column I will have different key value pair. For example:

For row8.Month = "JAN" I will have Key: "file_name_JAN" and Value: <path>/JAN.csv

In the 3. subjob I would like to use this global variable to create appropriate file.

But I received a java.lang.NullPointerException in component tFileOutputDelimited_2.

Why could the global variable not be used in the tFileOutputDelimited?

Re: Can not call a dynamic global variable in another subjob.

David_Beaty — Sun, 31 Dec 2023 09:14:13 GMT

The file name used in the tFileOutputDelimited_2 needs to be set before the flow starts - it can’t be part of the incoming flow. Consider using a tFlowToIterate component.

Re: Can not call a dynamic global variable in another subjob.

konvertilo — Thu, 11 Jan 2024 14:18:33 GMT

Hello

You could use the globalMap to store the name (subjob 2) and retrieve the filename and setting one context with the value you get from the globalMap.get() ?