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