cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
nath_baillet
Level II

Join data table : empty data result. Why?

Hi,

I have concatenated CSV files thanks to script I have found in a discussion.

There is to table result that I would like to join.

The first table is a 19 779 lines and 34 columns data table.

The second table is a 1 972 100 lines and 8 columns data table.

The comon column is the "NumeroCourbe".

I would like to get the 34 columns of the firts file joined to the 8 columns of the second file.

But the data table result is empty.

What can be the reason?


8851_join data table JMP.JPG

1 REPLY 1
Jeff_Perkinson
Community Manager Community Manager

Re: Join data table : empty data result. Why?

My guess is that your NumeroCourbe columns don't have any actual matches. Without seeing your data it's hard to say why they aren't matching. If the columns are numeric, try converting them to character. That will ensure that numeric precision issues aren't involved here. If they are character columns, try using Recode to Trim Whitespace and make sure the case matches between the tables.

Try turning on the options to include non-matches from both the main table and the with table. Then you can see that values that you think are matches aren't actually.

If you can post samples of the two tables we can better explain why there are no matches.

-Jeff

-Jeff