cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
cdwhite
Level II

Appending non-duplicate (single column ID) rows to a main table without creating a new table?

Scenario: need to append daily survey data files (that include all previous days) to a main table with only non-duplicative respondent ID records and without creating a new table (because I do not want to lose selected rows in the main table that are hidden or exluded

Two attempts:

Concatenate mainains the main table but brings over all records

Join brings only the new records but creates a new table so row characteristics (hide, exlcude) are lost

10 REPLIES 10
Martin
Level V

Re: Appending non-duplicate (single column ID) rows to a main table without creating a new table?

Excellent!!!

What got me confused was this line:

     Parse( "Col Min( Row(), :Name(\!"" || Concat Items( dt << get column names( string ), "\!"), :Name(\!"" ) || "\!"))" );


I couldn't figure out what the "Row()" in the first argument did.

Thank you very much.