cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
IrisK
Level II

Transfer columns with values to a new table

Please will you help me with this script. I'm trying to transfer a column full of items/values (some characters and Numerics) from an old table to a new table and this scripts is not fully working. I'm propably missing something. I'm sorry I'm new to JMP.

 

DATAtwo=Data Table("Results Extract");

testid = DATAtwo:column3 << Get Values; // Test

trans =Column(testid);

 

dtfour << New Column( "key", formula( trans[dtfour:column6] ) );

2 REPLIES 2
txnelson
Super User

Re: Transfer columns with values to a new table

Here is an example of how to do what you are looking for:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\Big Class.jmp" );

MyNames = dt:Name << get values;

dt2 = New Table( "new",
	New Column( "TheNames", character, values( MyNames ) ),
	New Column( "TheAges", values( dt:age << get values ) )
);
Jim
Jeff_Perkinson
Community Manager Community Manager

Re: Transfer columns with values to a new table

I always start by thinking of how I would do this interactively and then get the script from the resulting data table.

 

To create a new data table with only a some columns of an existing one, I'd use Tables -> Subset. 

 

If wanted to copy those columns to another existing data table I'd use Tables->Join. 

-Jeff