Copy rows and change one column value

[#1]

I'm finding the row documentation very frustrating. Is it possible to copy an entire row and add it to the current data table? My rows have many columns so I do not want to go through every column name doing this.

Alternatively, if it's possible to make a single one-way graph from two different data tables, then this will also solve my problem. Does JMP have that capability?

[#2]

You could make the one row a subset table, and then concatenate it with the larger table.

[#3]

Can you please reply with the JSL scrip for doing so?

[#4 · Accepted solution]

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\big class.jmp" );
// select a row
dt << select where( Row() == 5 );
// subset the data
dtsel = dt << subset( invisible, selected rows( 1 ), selected columns( 0 ) );
// put the tables together
dt = dt << Concatenate( dtsel, append to first table( 1 ) );
// delete the unneeded supbet table
colose( dtsel, nosave );

[#5]

Thank you this worked for me and I've obtained my end goal. 

[#6]

Here's an example that uses Big Class.  I make a subset table using row 8, and then append it back to the original Big Class table.

dt1 = open("$sample_data/Big Class.jmp");

// Make a subset using row 8
dt2 = dt1 << Subset( Selected Rows( 0 ), Rows( [8] ),
	Selected columns only( 0 )
);

// Concatenate the new table back to big class
dt1 << concatenate(dt2, append to first table);