Update/append existing Joined Table

GZ7853 — Sat, 10 Jun 2023 23:54:55 GMT

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 )
)

Re: Update/append existing Joined Table

jthi — Mon, 03 Oct 2022 20:01:01 GMT

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

topic Update/append existing Joined Table in Discussions

Update/append existing Joined Table

Re: Update/append existing Joined Table