- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How do I create a new table using another columns?(get columns from different tables)
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt1 = Open( "$SAMPLE_DATA/Iris.jmp" );
New Table( "Merge Columns",
Add columns( 3 ),
Add rows(100),
New Column( "1st",
Set Values( column(dt, 3 ) )
),
New Column( "2nd",
Set Values( column(dt, 1) )
),
New Column( "3rd",
Set Values( column(dt1, 1) )
)
);
Hi all.
I want to make a new table getting another columns by different tables.
How can I do that?
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How do I create a new table using another columns?(get columns from different tables)
Join is most likely the best option (match by row number if you don't have any column to use).
Then delete extra rows you don't need
-Jarmo
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How do I create a new table using another columns?(get columns from different tables)
Join is most likely the best option (match by row number if you don't have any column to use).
Then delete extra rows you don't need
-Jarmo