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