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)
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