Join and Sum

[RT4]

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!

[PhilipMannering]

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.

Thx

Phil

[RT4]

Hi Phil,

thanks for your fast response.

Not really sure how to join correctly after the transpose.

attached the inputs.

Thanks!

[atcodedog05]

Hi @RT4 

Can you explain the logic of the process.

[RT4]

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=)

[atcodedog05]

Hi @RT4 

Replace old codes with new codes and add up is right?

I am on it.

[PhilipMannering · Accepted solution]

Perhaps something like this?

Thx

Phil

[atcodedog05 · Accepted solution]

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 😀👍

[RT4]

Thanks a lot! Looks great😊

[RT4]

Thanks for the fast help!🙂