topic scenario based question in Talend Studio

scenario based question

joe86 — Sat, 16 Nov 2024 00:12:58 GMT

Hello All,

Greetings!

Here is my scenario.

I have a file with 1000 rows. I want to multiply each row with its own number.

For eg: row-1 * 1, row-2*2, row-3*3, row-4*4 ..... row-n*n.

Can anyone please help me to find an answer for this.

I thought we can use tRowGenerator to achieve this task, i could not get an idea to build it.

I have been using Talend for past 2yrs..

Any help at earliest will be helpful 🙂

gjeremy1617088143 — Tue, 27 Apr 2021 17:58:08 GMT

Hi you can use Numeric.sequence("s1 ",1,1) on a new field an then multiply by itself.

Send me Love and Kudos

JohnRMK — Sat, 08 May 2021 19:18:36 GMT

Hello

as suggested by Jeremy, here is the solution

The first tMap to assign the row number as a new column

the second tMap to perform the multiplication