ADDING AMOUNT IN A COLUMN TO ANOTHER COLUMN

[enkenmendoza]

Hi I want to know if how can I add some values (number) in my data. 

For example I have a data here:

Docno	Date	Code	Amount
11111111	1/21/2020	67218379	500
2222222	1/21/2020	37148375	800
3243443	1/21/2020	43257439	300
2222323	1/21/2020	34255466	303

I just want to add in a doc no:

11111111 + 500

2222222 + 600

expected output:

Docno	Date	Code	Amount
11111111	1/21/2020	67218379	1000
2222222	1/21/2020	37148375	1400
3243443	1/21/2020	43257439	300
2222323	1/21/2020	34255466	303

I have millions of lines but here is a sample only. How can I select only a doc number to add its amount. Hope you could help me with this one thanks!

[FredNajjar]

Hi @enkenmendoza 

Is there a logic to how numbers are added to the Docnos? 

[Qiu]

@enkenmendoza 

I think Find and Replace tool is a good fit for your situation.

You need to have input library to tell the workflow, which Doc No. needs to be add what amount.