topic Re: Get value after every n counts in Talend Studio

Get value after every n counts

Anonymous — Mon, 29 Apr 2019 15:53:29 GMT

Hi,

I get the max(ID) from the table which is BigDecimal(7,0). This value I am passing to tJavaRow component to assign the value to globalMap as below:
globalMap.put("startID", "1");
globalMap.put("endID", String.valueOf(row1.maxID));
globalMap.put("rowsToProcess", "40000000" );

OnComponentOK, connecting to tLoop component where the For loop is chosen as below:

From - 1

To - Integer.parseInt(globalMap.get("endID").toString())

Step - Integer.parseInt(globalMap.get("rowsToProcess").toString())

This raises NumberFormatException.

java.lang.NumberFormatException: For input string: "4979013401".

Is there any other way to generate value from start id to end id every n'th value.

Thanks.

Re: Get value after every n counts

TRF — Mon, 29 Apr 2019 16:08:40 GMT

Max value for an integer is 2,147,483,647...

Re: Get value after every n counts

akumar2301 — Mon, 29 Apr 2019 16:09:58 GMT

4979013401 is higher than above maximum possible value for Int

Instead try Long but you have to use While Loop instead of For( doesnot support Long)

start condition

Long i = 0L

Re: Get value after every n counts

Anonymous — Mon, 29 Apr 2019 16:18:18 GMT

Hi TRF,

System.out.println((Long)globalMap.get("tLoop_1_CURRENT_VALUE")); is returning NULL in tJava component.

How do I get the tLoop value ?

Thanks.

Re: Get value after every n counts

Anonymous — Mon, 29 Apr 2019 16:18:46 GMT

Hi,

System.out.println((Long)globalMap.get("tLoop_1_CURRENT_VALUE")); is returning NULL in tJava component.

How do I get the tLoop value ?

Thanks.

Re: Get value after every n counts

Anonymous — Mon, 29 Apr 2019 16:22:37 GMT

Hi,

System.out.println((Long)globalMap.get("tLoop_1_CURRENT_ITERATION"));

globalMap.get("tLoop_1_CURRENT_ITERATION") is by default Integer.

int current_iteration_tLoop_1 = 0;

How would it transfer Long value?

Is there any other way to achieve this?

Thanks.

Re: Get value after every n counts

akumar2301 — Mon, 29 Apr 2019 18:07:13 GMT

Hmm , If you need to use counter value in long
Immediately after tloop put a tjava and create a your own long globalmap
counter and use that custom value in your subjob