Multi Field formula to create iterative field function

[astanley537]

I have joined two similar tables and need to find the find the difference between the two. Each table has 132 Columns with data values (after the descriptive columns that the tables were joined on) labelled 1, 2, 3 and right 1, right 2, etc. I need to find a way of iteratively finding the difference between the corresponding columns, presumably using the multi field formula tool. Can anyone help me to do this?

[apathetichell]

that's not what multi-field formula tool does - multi-field formula converts fields into different types (ie strings to numbers)... regular formula can compare different columns.... is this as straightforward as [column 1]-[column 2] for 112 times? if so it would be MUCH easier to transpose your numeric columns pre-join and add name as a join condition. then you can  do [right value]-[left value]

and the attached workflow is an example to illustrate how this works...

[danilang]

Hi @astanley537 

The multi-field formula applies a single formula to multiple fields.  What you need is a dynamic formula based on the field name.  You can do this by transposing your data then applying a series operation on the transposed columns

Dan