topic Re: increment value of column in Talend Studio

increment value of column

NBen15 — Fri, 15 Nov 2024 23:13:43 GMT

Hello,

I have an excel file that contains data(tFileInputDelimited), I have to create a column that contains a value that increments by 10 for each product:

here is the input file

product | sub_product

product 1 | sub_product 1

product 1 | sub_product 2

product 1 | sub_product 3

product 2 | sub_product 5

product 2 | sub_product 6

here is the output file:

product | sub_product | incremental_value

product 1 | sub_product 1 | 10

product 1 | sub_product 2 | 20

product 1 | sub_product 3 | 30

product 2 | sub_product 4 | 10

product 2 | sub_product 5 | 20

in this case in each time we have a new product we increment by 10. I try to use tJava and tJavaRow bu i can't do this.

Can you help me please

gjeremy1617088143 — Wed, 09 Feb 2022 15:51:07 GMT

Hi, sequence can help you , for eg in the tmap output field you want to increment :

Numeric.sequence("s1",10,10)

Send me love and kudos

NBen15 — Wed, 09 Feb 2022 16:03:35 GMT

@gjeremy1617088143 Thanks for your feedback

I have already tried this solution but it increments all the fields to 10, I get 10,20,30,.... even if I change product.

gjeremy1617088143 — Wed, 09 Feb 2022 16:13:48 GMT

it's normal you have to use one sequence for each product

so if product is a String data :

for eg : if your main input is row1 and the input field is product

Numeric.sequence(row1.product,10,10)

NBen15 — Wed, 09 Feb 2022 16:22:58 GMT

@gjeremy1617088143 it works very well thank you very much