Repeat column Calculations- not using formula tool

Denise_Chin

Hi

I'll like to be able to compare 2 sets of data

As an example in excel

Col A to C: Data set 1

Col D to E: Data set 2

Col G: I : Diff in Data set 1 & 2

how can I do Col G: I   iteratively without applying the formula tool 3 times e.g. iterative loop? like the excel spreadsheet

Example Repeat column Calculations- not using formula tool.xlsx

apathetichell

Here's an example of how I would do it... 

Two major parts:

1) Transpose all values in each row. Then you use a multi-row formula to get the (formerly columns - now rows) delta. Crosstab these entries and add "Diff" as a prefix.

2) Join with the original dataset based upon Record ID.

dynamic column matching.yxzp