How do I create a new table using another columns?(get columns from different tables)

[#1]

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?

[#2 · Accepted solution]

Join is most likely the best option (match by row number if you don't have any column to use).

jthi_0-1705571641478.png

Then delete extra rows you don't need