Why won't my data tables join

[Christine Gopon]

I am trying to join two data sets, using a unique identifier column.

The main datatable has 22541 rows and 52 columns. One of those columns is the identifier column.

The second datatable has 24,845 rows and 13 columns, including the identifier column. There are some additional rows here that I know will not match and be left out after the join.

 

The problem is that I cannot get the data to join. I've tried using the identifier, using other columns in common, trimming the identifier to make sure the were no extra spaces. Nothing. When I try to join, the new columns from the second dataset are never populated. Am I doing something wrong Is the size of the dataset an issue I'm at a bit of a loss here.

[Steven van der Kroft]

Hi Christine,

Are the data types of the columns the same Otherwise a transformation would help to make them the same data type before the join.

This can be done from the table flyout where you also choose 'Add Columns to'

Hope this helps

[Christine Gopon]

Yes, they are both string datatypes. All identifiers are unique (i.e. no repeats). I've tried joining the data in so many different ways, and it just won't budge. I've been working with relatively large datasets for a while and I've always been able to join datatables with an identifier, so I am not sure what's amiss here. 

[Fabian Duerr]

Could you share (a sample of) your data or provide a screenshot of the join process 

[Steven van der Kroft]

A Sample of the data or at least the columns you are trying to join on would be really helpful indeed.

 

without trying to state the obvious, for the string columns, a trim() or upper()/lower() function can help in case to trailing spaces and or different case.