This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
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: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
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 (20370 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 (832 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