I want to be able to use this kind of logic in the multi-field tool: Expression of [_CurrentField_]-['SOURCE_2_'+[_CurrentFieldName_]]
I am comparing values for a single field from two data sources. After joining the two data sources, I want to be able to use a multi-field tool to iterate over all Source_1 columns needing the comparison to Source_2 expression above. This is WAY easier than writing hundreds of
Source_1_Sales - Source_2_Sales
Source_2_Orders - Source_2_Orders
In the formula tool.
I know you can get this done w/ transpose-summarize, I just feel like this shouldn't be that hard to do with a multi-field tool.
I've attached a mock up.