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
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.