HOW TO ADD NUMBERS BASED ON CONDITION

Question

Hey guys, I would like to ask if how can I add numbers in a row based on a given code. I have a data here:

CodeAmount7458495007.56

43575-40043554890

then I want to add these numbers to each code:

74584 = 700

43575= -50

43554= 10

Expected Amount:

CodeExpected Amount7458495707.5643575-45043554900

Can you help me with this one pls?

HomesickSurfer · Answer

Hi @dunkindonut7777

Keep it simple and efficient:

Use Select Tool to modify the [Amount] field to Type: FixedDecimal, Size: 19.2, then using a Formula Tool, modify the [Amount] field values using the following expression:

If you have additional codes, modify accordingly.

IF [Code]=74584 THEN [Amount]+700 ELSEIF [Code]=43575 THEN [Amount]-50 ELSEIF [Code]=43554 THEN [Amount]+10 ELSE [Amount] ENDIF

atcodedog05 · Answer

Hi @dunkindonut7777

Just extending on @AngelosPachis solution and doing a full left join so that data is not missed out. If the code is not present in the list then the add is 0.

Workflow:

Hope this helps : )

example (2).yxmd

AngelosPachis · Answer

Hey @dunkindonut7777 ,

Maybe something like this works in your occasion

example.yxmd