Join, Concat and Update

[vhuac]

Every day we have new data that need to add/update to the existing data table  I need a simple operation that will be able to concatenate new row(s) and/or new column(s) to the existing table and also update the existing table if the new table show a change in the data value by matching columns criteria.

[hogi]

#DiscoverySummit2025

dt = Current Data Table();
dtnew = dt << Run Script( "Source" );
dt << Select All Rows << Delete Rows;
dt << Concatenate( dtnew, Append to first table );
Close( dtnew, NoSave );

this shot script is a very universal solution for the problem
- till JMP overwrites the source script.

[jthi]

This can be done with Join platform, but it will always generate new table which can be annoying and user has to know to use full outer join with update main table... option. I think JMP should either implement new table platform or possibly update the Update platform with option of adding new rows. Effective concatenation without duplicates using scripting by matching data in two columns in differ... . Like usually, I have written my own functions to do this, but I think JMP implemented one would be much faster.

If this was a new platform, I would be fine (or possibly even prefer) if this wouldn't even add new columns and would just insert new rows and update existing values. This is quite common operation with databases, upsert (update + insert).