Merging 2 tables
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Developer
- Input
- Join
- Output
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hey @Felipe_Amancio
You should be able to perform this merge by using the join tool, see attached mock up.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It didnt work :(
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It didnt work as the as the "Balance" and "Validation" of the last 2 rows should be under "Right_Balance" and "Right_Validation" columns.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Felipe_Amancio Good catch! Try this one, should fix the issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Perfect! You the man!
![](/skins/images/2A479D0ADEFDAA8078B5B9F489A80DDD/responsive_peak/images/icon_anonymous_message.png)