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
Images:
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.
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.
Thanks Brian, It works now :)