Merging Data Tables and Duplicate Column Created

I’m trying to merge two data tables together which works perfectly fine apart from an additional duplicate column being created that i want to remove.

Both tables have a common field for Company Name which does merge perfectly but an additional Company Name column is created that just populates with the Source data but leaves blank spaces for the destination data. Any ideas for what is causing this to happen?

Test.xaml (6.2 KB)

Test.xlsx (21.0 KB)

Column [Company Name] != [Company name] . It is case sensitive.

Yeh just realised. Thanks!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.