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: 
Check out the JMP® Marketplace featured Capability Explorer add-in
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 (26790 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 (1921 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 (1899 views)  |  Posted in reply to message from alxh 11-06-2016

Thanks for all the help on this everyone!

0 Kudos