topic Re: Copy rows and change one column value in Discussions

Copy rows and change one column value

rossjason — Wed, 15 Mar 2017 17:40:33 GMT

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?

Re: Copy rows and change one column value

pmroz — Wed, 15 Mar 2017 17:40:30 GMT

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

Re: Copy rows and change one column value

rossjason — Wed, 15 Mar 2017 17:41:22 GMT

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

Re: Copy rows and change one column value

txnelson — Wed, 15 Mar 2017 18:13:00 GMT

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 );

Re: Copy rows and change one column value

pmroz — Wed, 15 Mar 2017 18:25:04 GMT

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);

Re: Copy rows and change one column value

rossjason — Wed, 15 Mar 2017 20:35:47 GMT

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