Insert list of column names into a formula

Daniel_Lea

Hi,

 

I am making a script creating about 14 different journals.  I have maybe 10 different sets of data that am going to prepare and for each for each journal I would like to update specific data from other tables and then also chart the specific data.   The chart settings for my script are more complicated than the sample script I supplied.  Please help me figure out how use a variable for the column names in my script.  I've tried a bunch of combinations of Parse, eval and expr and couldn't get it to work

 

Would like to do something like this:

 

table1 = open("$SAMPLE_DATA/students1.jmp");
table2 = open("$SAMPLE_DATA/students2.jmp");

ins = ":height, :weight";

table1 << Update(With( table2 ),
Match Columns( :name = :name ),
Add Columns from Update table( parse(ins) ));


Current Data Table(table1);

Scatterplot Matrix(
	Y( parse(ins) ),
	X( :sex ),
	Matrix Format( "Lower Triangular" ),
	Ellipse Color( 3 ),
	Fit Line( 0 )
);

and result I would like to be like this:

 

table1 = open("$SAMPLE_DATA/students1.jmp");
table2 = open("$SAMPLE_DATA/students2.jmp");



table1 << Update(With( table2 ),
Match Columns( :name = :name ),
Add Columns from Update table( :height, :weight ));


Current Data Table(table1);

Scatterplot Matrix(
	Y( :height, :weight ),
	X( :sex ),
	Matrix Format( "Lower Triangular" ),
	Ellipse Color( 3 ),
	Fit Line( 0 )
);

txnelson

Here is an old school way of handling your issue

names default to here(1);
table1 = open("$SAMPLE_DATA/students1.jmp");
table2 = open("$SAMPLE_DATA/students2.jmp");

ins = ":height, :weight;";

eval(parse(
"table1 << Update(With( table2 ),
Match Columns( :name = :name ),
Add Columns from Update table( "||ins||" ));"));


Current Data Table(table1);

Scatterplot Matrix(
	Y( parse(ins) ),
	X( :sex ),
	Matrix Format( "Lower Triangular" ),
	Ellipse Color( 3 ),
	Fit Line( 0 )
);