Merge Two tables with multi-index with inner or outer merge method

talebi

Forums

Hello,
Unfortunatelly, I could not find any tasks in IDEA to merge two tables which has two or more keys (multi-index). Visual Connector has limitation and just accepts one key (index) which does not work in my project. Is there any way to do that
Please take a look at Python (Pandas) example attached
 

Brian Element Tue, 11/30/2021 - 10:28

The second one is a match with the Right being the primary database and the Left being the secondary database.  The match key is key 1 and key 2.  Your join is matches only and you will get your result.

Brian Element Tue, 11/30/2021 - 10:33

The first one is another match set-up the same as above but the match options is all records in both databases.  The view is different as it doesn't merge the keys together but the information is the same.