Multi Field formula to create iterative field function

Question

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?

danilang · Answer

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

MultiColumnDifferences.yxmd

apathetichell · Answer

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

112 columns of fear.yxmd