Hello!
Have two tables to join and sum based on multiple columns:
The first table is:
The second one is:
How to get the results as following?
Thanks in advance!
Perhaps something like this?
Thx
Phil
Hi @RT4
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂 Feel to ask if you have any questions
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
So the process for this would be to pivot table 1 (Transpose Tool) then join the two tables (Join Tool) and add up the amounts per D-code (Summarize Tool). If you wanted to share the data, I'm sure someone can mock up a solution for you.
Hi Phil,
thanks for your fast response.
Not really sure how to join correctly after the transpose.
attached the inputs.
Thanks!
