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
GZ7853
Level I

Update/append existing Joined Table

I have an ongoing data set made from the following.  Table A and Table B are joined to make Table AB.  I am adding new samples to Tables A and B. 

 

I want to update Table AB to include the newly added data.  I can do this via the Source code in Table AB, but this yields a new table but does not carry my added work in AB (value ordering, colors, charting, etc).  Is there a way to update (auto-append to) Table AB using the join function without creating a new table?  I am not much of a coder, so a point and click solution is preferred.  But I'll take what I can get!!

 

existing script to create the new joined table (NOT preferred) is:

Data Table( "DSTL - Peel Master" ) << Join(
	With( Data Table( "DSTL - DD Master" ) ),
	By Matching Columns( :Sample Name = :Drawdown ),
	Drop multiples( 0, 0 ),
	Include Nonmatches( 0, 0 ),
	Preserve main table order( 1 )
)

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Update/append existing Joined Table

If you know which are the new samples and samples are being added as rows, then one idea could be to

  • first join A and B together with new samples
  • then select those new samples and create subset out of them
  • then concatenate those to your old AB data table
-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: Update/append existing Joined Table

If you know which are the new samples and samples are being added as rows, then one idea could be to

  • first join A and B together with new samples
  • then select those new samples and create subset out of them
  • then concatenate those to your old AB data table
-Jarmo