topic Re: Getting row-Vars in tJava in Talend Studio

Getting row-Vars in tJava

Anonymous — Wed, 28 Sep 2016 10:59:41 GMT

Hi together,

in the tMap-Componente there are several row-Vars, but when i show them in tjava with

System.out.println( "row2 from tMap: " + row2.toString());

all vars are "null" - in a following logrow the vars will be shown.

Any idea whats wrong?`

Re: Getting row-Vars in tJava

Anonymous — Wed, 28 Sep 2016 11:49:49 GMT

Can you show us your job layout? Also, are you using tJava or tJavaRow or tJavaFlex components for this?

Re: Getting row-Vars in tJava

Anonymous — Wed, 28 Sep 2016 12:00:26 GMT

Yes, please show the image below.
It's strange, that the last component tLogRow print

 Column1          | 20160927

but in tJava

System.out.println( "Test:" + OUT2.Column1);

the output is

Test: null

Here is the job layout:

Re: Getting row-Vars in tJava

Anonymous — Wed, 28 Sep 2016 12:06:21 GMT

Can you change the tJava to be a tJavaFlex with the same code? Select the "Data Auto Propagate" checkbox to ensure that all data is propogated without requiring code.

Re: Getting row-Vars in tJava

Anonymous — Wed, 28 Sep 2016 12:07:27 GMT

Put the code in the "main code" section

Re: Getting row-Vars in tJava

Anonymous — Wed, 28 Sep 2016 12:35:12 GMT

I have done that - but the same effect, output from
System.out.println( "Test " + OUT3.BildFullPath );
is

Test null

But in the logrow, the value of the var is printed:

BildFullPath     | full/401448/910/

Re: Getting row-Vars in tJava

Anonymous — Wed, 28 Sep 2016 12:47:14 GMT

Can you click on the "OUT3" link and show me the columns that are set up for it and also show me the code in the tJavaFlex?

Re: Getting row-Vars in tJava

Anonymous — Wed, 28 Sep 2016 13:03:00 GMT

Thanks for your engagement ;-)
The code in tJavaFlex is:

System.out.println( "Test " + OUT4.Column1);

And here a screen from the Row:

Re: Getting row-Vars in tJava

Anonymous — Wed, 28 Sep 2016 13:30:09 GMT

You aren't using a tJavaFlex. You are using a tJava. Can you use the tJavaFlex and ensure that the "Data Auto Propagate" checkbox is ticked.

Re: Getting row-Vars in tJava

Anonymous — Wed, 28 Sep 2016 13:54:50 GMT

Sorry, that was an old screen You are right: Now, with the code in the main area, it works. The aim is, to get the values from the row to a following tftpGet-Component. So I think in the javaflex-Component, i can define a global variable, and then use it e.g. as a download-Path in ftpget

Re: Getting row-Vars in tJava

Anonymous — Wed, 28 Sep 2016 14:50:30 GMT

Use a tFlowToIterate component connected to the tMap. Then connect the FTP component to the tFlowToIterate using the Iterate connector. The tFlowToIterate component will create globalMap variables with the format {rowname}.{columnname} which can be used. So if your row connecting the tMap to the tFlowToIterate is called "row2" and your column name is called "column1", a globalMap variable with a key of "row2.column1" will be created. You can access this in the ftp component with ((String)globalMap.get("row2.column1")) ......assuming it is a String value.