Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂
Hi you can use Numeric.sequence("s1 ",1,1) on a new field an then multiply by itself.
Send me Love and Kudos
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