scenario based question

[joe86]

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]

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

Send me Love and Kudos

[JohnRMK]

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