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
Solved! Go to Solution.
hey @Felipe_Amancio
You should be able to perform this merge by using the join tool, see attached mock up.
It didnt work :(
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.
It didnt work as the as the "Balance" and "Validation" of the last 2 rows should be under "Right_Balance" and "Right_Validation" columns.
@Felipe_Amancio Good catch! Try this one, should fix the issue.
Perfect! You the man!