Copying Columns Between Data Tables Without Altering the Main Data Table

BabyDoragon — Fri, 23 May 2025 09:00:13 GMT

In the JSL below, this allows for the copying of columns between different data tables. However, I actually don't want to change the current main data table with `Current Data Table()`. Is there a way to modify it so that I can copy columns to another specified data table without altering the current main data table?

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt2 = Open( "$SAMPLE_DATA/Big Class Families.jmp" );

dt << New Formula Column(
	Operation( Category( "Combine" ), "Ratio" ),
	Columns( :height, :weight )
);

script = Column(dt,"height/weight") << get script;

Current data table(dt2);
script;

Re: Copying Columns Between Data Tables Without Altering the Main Data Table

jthi — Fri, 23 May 2025 09:09:56 GMT

You can for example use Send()

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt2 = Open( "$SAMPLE_DATA/Big Class Families.jmp" );

dt << New Formula Column(
	Operation( Category( "Combine" ), "Ratio" ),
	Columns( :height, :weight )
);

script = Column(dt,"height/weight") << get script;

Eval(EvalExpr(Send(dt2, Expr(Name Expr(script)))));

topic Copying Columns Between Data Tables Without Altering the Main Data Table in Discussions

Copying Columns Between Data Tables Without Altering the Main Data Table

Re: Copying Columns Between Data Tables Without Altering the Main Data Table