cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
cdwhite
cdwhite
Level II

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

May 8, 2015 09:57 AM (22243 views)

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

0 Kudos
10 REPLIES 10
Martin
Martin
Level V

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

May 15, 2015 03:14 PM (1092 views)  |  Posted in reply to message from robot 05-15-2015

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.

0 Kudos