Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
yashfreaky
Contributor
Contributor

Incremenal adding with above number

Hello Talend Developers,

Could any one help me in sorting out the below scenario

 

I have input data like 

id|name

1|abc

2|adg

3|edc

4|tgv

5|sai

6|hil

 

and need to get o/p like 

id|name|number

1|abc|1

2|adg|1

3|edc|2

4|tgv|3

5|sai|5

6|hil|8

Labels (2)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

@yashfreaky ,check the below one.

 

0683p000009M2ll.png

0683p000009M2i5.png

View solution in original post

3 Replies
manodwhb
Champion II
Champion II

@yashfreaky ,how do you want to increment ? based on what ? is that output is correct one?

yashfreaky
Contributor
Contributor
Author

Hi Manohar, Thank you for the quick response

please find the below process

 

0   

1   |1+0=1
1   |1+1=2

2   |2+1=3

3   |3+2=5

5   |5+3=8   like wise incremental add for last column @manodwhb

manodwhb
Champion II
Champion II

@yashfreaky ,check the below one.

 

0683p000009M2ll.png

0683p000009M2i5.png