This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
Could you please share the alternative solution - how would you transpose/summarize this? I was also hoping to use the Multi-field tool for this issue, but reading your thread, I understand that's not possible. The only alternative I thought of is using the standard formula tool. I hadn't thought to transpose/summarize and I am curious how you guys would use transpose/summarize.