topic Re: Calling Globalvariable in Expression builder returns null in Talend Studio

Calling Globalvariable in Expression builder returns null

Anonymous — Fri, 08 Nov 2019 07:22:30 GMT

Hi,

I am passing my rows through tAggregateRow and getting the max value of a particular row and storing it in tSetGlobalVar. But when I call the global variable inside my expression builder, its value is null but when I pass it through tLogRow, it gives me the correct value. Can you help me with this?

I am trying to populate the primary key for my incremental load.

Re: Calling Globalvariable in Expression builder returns null

manodwhb — Fri, 08 Nov 2019 08:04:07 GMT

@uchihammd , you need to design the below way to call the global var in tmap. have you design this way?

Re: Calling Globalvariable in Expression builder returns null

Anonymous — Fri, 08 Nov 2019 08:53:40 GMT

Hi @manodwhb ,

That was the design I was using. Initiating the global variable using a prejob. But, it was not working.

I have attached the screenshot below.

In that, If I call my Variable in tlogrow. It works. I just print it immediately after the globalvariable component.

The same doesn't work if I print it in a tjava component.

The tJava component has a simple print statement.

System.out.println((Integer)globalMap.get("myKey"));

Can you please point out what I am doing wrong?

Re: Calling Globalvariable in Expression builder returns null

manodwhb — Fri, 08 Nov 2019 09:11:22 GMT

@uchihammd , You need to use on Component of from tSetGlobalvar to tjava.then it will work.

Re: Calling Globalvariable in Expression builder returns null

Anonymous — Fri, 08 Nov 2019 09:24:40 GMT

Hi @manodwhb ,

In the second screenshot, I have used tjava from tSetGlobalVar. Shouldn't it work?

Re: Calling Globalvariable in Expression builder returns null

manodwhb — Fri, 08 Nov 2019 09:36:38 GMT

@uchihammd , no it will give null, since tjava code execute first , you have to use trigger from tSetglobalvar like on component ok.

Re: Calling Globalvariable in Expression builder returns null

Anonymous — Fri, 08 Nov 2019 09:42:03 GMT

Hi @manodwhb ,

I used the condition. But, I am still getting null. Please find the screenshot below.

Re: Calling Globalvariable in Expression builder returns null

manodwhb — Fri, 08 Nov 2019 09:54:44 GMT

@uchihammd ,should be below way in tjava

System.out.println((Integer)globalMap.get("maxrow"));

Re: Calling Globalvariable in Expression builder returns null

Anonymous — Fri, 08 Nov 2019 10:04:01 GMT

Hi @manodwhb ,

This is my code. While querying from the db, I get the max of the particular column. So, I will have just one row. And I am calling that row. So,I don't think I need to call maxrow.

Re: Calling Globalvariable in Expression builder returns null

manodwhb — Fri, 08 Nov 2019 10:27:21 GMT

@uchihammd , please find the below solution.

Re: Calling Globalvariable in Expression builder returns null

manodwhb — Fri, 08 Nov 2019 10:28:18 GMT

@uchihammd ,issue is tSteglobalvar value.chekc that .

Re: Calling Globalvariable in Expression builder returns null

Anonymous — Fri, 08 Nov 2019 10:30:41 GMT

Hi @manodwhb ,

I was just calling the connection but not the column name so it didn't work. Now it works.

Thanks!

Re: Calling Globalvariable in Expression builder returns null

manodwhb — Fri, 08 Nov 2019 10:31:32 GMT

@uchihammd ,please mark the solution and also provide kudos.