Merging 2 tables

[Felipe_Amancio]

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

[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

[gautiergodard]

hey @Felipe_Amancio 

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

[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 · Accepted solution]

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

[Felipe_Amancio]

Perfect! You the man!