Merging two tables

[Jakuza]

I feel like I'm completely missing something here. I'm not sure if I'm just doing this wrong but I can't seem to merge these two tables. Essentially, I have two tables pulled from different sources, one is from Exchange and the other is from AD. I am trying to link the computers from Exchange with the operating systems from AD, both have the "Computers" column but when I try to merge I get a "The selection has matched 0 out of the first 178 rows." I'm not sure what I'm doing wrong. I've also tried creating a relationship but nothing happens. Any help would be appreciated.

[MFelix]

Hi @Jamuza,

Are you sure that both colimns from wich you want to merge the tables have the same data? Do.you have any spaces in the end of the text in one of them that makes the information be different for example.

Regards,
MFelix

[Jakuza]

Hi,

I'm pretty positive they're the same. Here's an example of two same items:

[MFelix]

Are the columbs both formatted in the same way? Sorry for asking.again.are you sure the columns are exactly the same? Add a column with the length of the merging columns and compared them, I ask this because I had cases in.wich I.was also sure of the columns being equal and there were spaces in one of.them.

MFelix

[Jakuza]

So I created a brand new column and tried to merge them both, still the same issue. They're both text, I also tried a merge different tables and it does work, so that leads me to believe something is wrong with one of my tables. Is there a way to format the table to match the other tables?

[Jakuza · Accepted solution]

I FIXED IT! You were right, something was wrong with that column, I did a split column and got rid off whatever was causing the issue. Kind of weird since I didn't see anything.