# Merge join add new column

**URL:** https://community.automationedge.com/t/merge-join-add-new-column/2763
**Category:** Get Help & Discuss
**Tags:** rpa
**Created:** [January 3, 2021, 11:40pm UTC](https://community.automationedge.com/t/merge-join-add-new-column/2763 "2021-01-03T23:40:30Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![thais.orgeira](https://avatars.discourse-cdn.com/v4/letter/t/e495f1/32.png) [@thais.orgeira](https://community.automationedge.com/u/thais.orgeira)
#### Post date: [January 3, 2021, 11:40pm UTC](https://community.automationedge.com/t/merge-join-add-new-column/2763/1 "2021-01-03T23:40:30Z")

</div>

I guys, when I’m tryng to merge two excel files (using merge join) output comes with duplicated. They add a new column and values who doesnt exist come if null.

Example:  
Column 1  
1 - A  
2 - B  
3 - C

Column 2  
1 - Robert  
2 - Carl  
3 - Peter

After merge join:  
1 - Robert - null - null  
null - null - 1 - A  
2 - Carl - null - null  
null - null - 2 - B  
…

---

<div class="post-metadata">

### Author: ![Garr14](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/garr14/32/824_2.png) [@Garr14](https://community.automationedge.com/u/Garr14)
#### Post date: [January 4, 2021, 9:57pm UTC](https://community.automationedge.com/t/merge-join-add-new-column/2763/2 "2021-01-04T21:57:01Z")

</div>

Hi Thais,

Hope you are doing well.

Kindly refer the video below for your query:

[![](https://img.youtube.com/vi/99VW-DTY-dQ/hqdefault.jpg "AutomationEdge for Dummies: Merge Join (With Subtitle)") ](https://www.youtube.com/watch?v=99VW-DTY-dQ)