Column Matching Issue

I have 2 tables, both are related via the ID column by exact matches. 


When I try to create a Column match between the tables using the ID columns Spotfire acts like I'm putting Sqaure pegs in round holes and can't find any matches between the columns, although I can put the tables side by side and see that each table has the exact same numbers in their ID columns. I've ensured that both columns are the same data type, still no matches. 


What could be causing this? Is it because one of the tables is a .shp file and the other is an .xlsx?

(1) Answer