cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
marshmadness98
Level II

Joining Multiple Data Tables

Hiya!

 

I am having issues merging these two data tables. For some reason, every way I merge them, I end up with 60,000+ rows. I know I should be able to just join the tables or update the information from table two into table one, but I am stuck. I thought of trying the Query builder, but I am confused, and I also do not know how to code so I cannot join the tables that way. 

 

Thoughts?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Joining Multiple Data Tables

Try using Join and Match with two columns:

jthi_0-1628783526413.png

jthi_1-1628783554146.png

 

 

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: Joining Multiple Data Tables

Try using Join and Match with two columns:

jthi_0-1628783526413.png

jthi_1-1628783554146.png

 

 

-Jarmo
marshmadness98
Level II

Re: Joining Multiple Data Tables

Thank you for your kindness!