- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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] ) );
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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 ) )
);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.