cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • See how to interactively organize and restructure data for analysis. Register for May 29 webinar, 2pm US ET.

Discussions

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

Recommended Articles