topic Copy Last Two Column data from Data table A to Data table B in Discussions

Copy Last Two Column data from Data table A to Data table B

wade-liu — Fri, 08 Dec 2023 06:35:00 GMT

Hi Everyone

I have a two data table , table A and table B,

I want write a script that copy last two column data from table A then paste to table B,

Could you give me some kindly sugestion ?

Thanks.

Re: Copy Last Two Column data from Data table A to Data table B

jthi — Fri, 08 Dec 2023 07:26:48 GMT

Do the tables have exactly same amount of rows and order of data is exactly the same in both of the tables?

Re: Copy Last Two Column data from Data table A to Data table B

wade-liu — Mon, 11 Dec 2023 09:12:39 GMT

Yes, But I don't know how to use script syntax to copy entire column information to another table.

Re: Copy Last Two Column data from Data table A to Data table B

jthi — Mon, 11 Dec 2023 09:21:27 GMT

You can use Join/Update or . Below is one example using update which might work for you

Names Default To Here(1);

// Setup demo
dt = Open("$SAMPLE_DATA/Trial1.jmp");
dt2 = Open("$SAMPLE_DATA/Little.jmp");

dt << Delete Rows(5 :: N Rows(dt)); // to make tables equal in size
Column(dt2, "batch") << Set Name("B"); // names must be different
Column(dt2, "yield") << Set Name("Y"); // names must be different
Wait(0);


collist = dt2 << Get Column Names("String");
lastcols = Right(collist, 2);
dt << Update(
	With(dt2),
	Add Columns from Update Table(Eval(lastcols)),
	Replace Columns in Main Table(None) // important
);