topic Re: how to pass single table row values in Talend Studio

how to pass single table row values

Anonymous — Mon, 08 Jul 2019 17:04:00 GMT

hello,

in my scenario

i want to find difference between row 1 and row 2 then 2 and 3 and so on.

my table type is ..

id, object_Lattitude, object_longitude

1, 41.273,-72.236

2,1, 41.277,-72.236

3,1, 41.252,-72.236

i use this components to find difference between

tDbinput --.> tjavarow-->tDboutput, i also write routines

tJavarow--> latA, longA, latB & longB and

ques:- i want to pass 1st row data as latA, longA, 2nd row data as latB & longB

thanks in advance,

regards ,

Manish

Re: how to pass single table row values

Anonymous — Tue, 09 Jul 2019 04:48:48 GMT

Hi,

Could you please refer the below post which is having solution to similar query?

https://community.talend.com/t5/Design-and-Development/How-to-get-previous-row-tuple-s-value-without-using-Custom-Code/td-p/121465

You may have to make minor changes to suit your specific use case.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: how to pass single table row values

nfz11 — Tue, 09 Jul 2019 05:25:29 GMT

Use tMemorizeRows. The example in the documentation is very similar to what you need:

https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/0oEBI6YCTFXSgc5Z9Gpr6Q

If you set 'Row count to memorize' to 2, you can reference the current row as index 0 and the last row as index 1. In your tJavaRow component, you can compute the difference:

int latDifference = object_Lattitude_tMemorizeRows_1[0] - object_Lattitude_tMemorizeRows_1[1];
int lonDifference = object_longitude_tMemorizeRows_1[0] - object_longitude_tMemorizeRows_1[1];

Re: how to pass single table row values

Anonymous — Tue, 09 Jul 2019 15:22:00 GMT

thanks @nthampi sir for help, the solution is working !!