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
The second one is a match
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.