Merging 2 tables

Hi Masters

I need your help to merge two tables. One is the previous month calculation loaded as an input. The other is an output of the current month calculation.

The ultimate goal is to be able to deduct the previous month calculation from the current month (see excel file attached)

Thanks

Merging 2 tables.xlsx

Developer

Input

Output

Join

Preparation

Accepted answers

gautiergodard

@Felipe_Amancio Good catch! Try this one, should fix the issue.

New Workflow14.yxmd

All comments

Link

Hi Felipe,

I hope I understand your usecase, it might work already with a Join by choosing two specific field to join (Provider & Receiver).

You can look at me screenshot for further clarification.

After the join you could insert a formula and deduct the Balance.

Regards

Ben

Felipe.png

gautiergodard

hey @Felipe_Amancio

You should be able to perform this merge by using the join tool, see attached mock up.

New Workflow14.yxmd

Felipe_Amancio

It didnt work

gautiergodard

Hey @Felipe_Amancio can you kindly accept the post that provided you the solution? This will help others with similar problems find the answers in the future.

Felipe_Amancio

It didnt work as the as the "Balance" and "Validation" of the last 2 rows should be under "Right_Balance" and "Right_Validation" columns.

gautiergodard

@Felipe_Amancio Good catch! Try this one, should fix the issue.

New Workflow14.yxmd

Felipe_Amancio

Perfect! You the man!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703