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
ShannonK
Level II

How do I join two data tables without losing data?

I am trying to Join two tables. I am using three common Source Columns as matches. When I get the new output table, it is missing data. I have selected 'Merge same name columns' and 'Include non-matches' before creating the new table. The three Source Columns appear to be exact matches in the rows that have missing data. What would cause me to lose data when creating the new table? I am not scripting and would prefer an interactive explanation referring to the menu items and GUI windows.

Thanks for any tips.

11 REPLIES 11
alxh
Level II

Re: How do I join two data tables without losing data?

RECODE is your friend here. Trim whitespace in no time at all via the red triangle menu.

Cols > Recode or Cols > Utilities > Recode depending on your version of JMP
ShannonK
Level II

Re: How do I join two data tables without losing data?

Thanks for all the help on this everyone!