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!
Can you explain the logic of the process.
Hi atcodedog05
Sure, updated the sample file.
I think now it's more clear.
There are two inputs with new codes, which are combining a few old ones.
And the second table has the sums per old code.
The result should be as an output in the sample.
Hope now it's more clear=)
