Horw to achieve below scenario

[BhabanishankarBehera3]

Column_name	A	Old_A	B	Old_B
A	20	10	30	20
B	20	10	30	20
C	20	10	30	20
D	20	10	30	20

In Column_name field I have stored all the actual field names where amounts are present.

I want to do a loop on all the fields stored in the column_name field and perform one formula dynamically, with field name same as that stored in column_name field values like below:

When Coulumn_name=A then (old_A-A)

Coulumn_name=B then (old_B-B)

Coulumn_name=C then (old_C-C)

Coulumn_name=D then (old_D-D)

[AndrewDMerrill]

I'm not sure if this meets your requirements, but is does capture the difference for all columns that are present. This shouldn't be too difficult to reconfigure as necessary if your needs are slightly different.

[flying008]

Hi, @BhabanishankarBehera3 

FYI.

[BhabanishankarBehera3]

Hi _@flying008

Can you attach the complete code.As I am new to Alteryx,i am unable yo understand the configuratikn of each component used.Like how we are doing find and replace.

Thanks