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

NetflixDingo567 — Thu, 18 Jan 2024 09:46:10 GMT

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?

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

jthi — Thu, 18 Jan 2024 09:54:49 GMT

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

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

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

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