User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
ShannonK
ShannonK
Level II

How do I join two data tables without losing data?

Nov 3, 2016 08:07 PM (35214 views)

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

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

Nov 6, 2016 08:59 PM (3278 views)  |  Posted in reply to message from ShannonK 11-04-2016
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
ShannonK
Level II

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

Nov 9, 2016 02:35 PM (3256 views)  |  Posted in reply to message from alxh 11-06-2016

Thanks for all the help on this everyone!

0 Kudos

Recommended Articles