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
…
