Join data table : empty data result. Why?

nath_baillet — Tue, 18 Oct 2016 23:26:05 GMT

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?

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

Jeff_Perkinson — Tue, 16 Jun 2015 19:14:51 GMT

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

topic Join data table : empty data result. Why? in Discussions

Join data table : empty data result. Why?

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