cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles