topic Re: Simplify JSL in transpose column # in Discussions

Simplify JSL in transpose column #

Stokes — Fri, 09 Jun 2023 15:59:44 GMT

Hi I am trying to reduce the transpose JSL columns.

Currently, when transpose col from col (3) to col (8), each col needs to be listed specifically.

Can I convert it to transpose between col (3) and col (8)? without list each column name.

Thanks

dt = Current Data Table();
dt << Transpose(
	columns(
		Column( 3 ),
		Column( 4 ),
		Column( 5 ),
		Column( 6 ),
		Column( 7 ),
		Column( 8 )
	)
);

txnelson — Wed, 05 Oct 2022 22:06:58 GMT

Here is one way to do what you want

dt = Current Data Table();
colNames = (dt << get column names(string))[3::8];
dt << Transpose(
	columns(
		colNames
	)
);

ErraticAttack — Thu, 06 Oct 2022 01:39:06 GMT

You can index the columns by number:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Blood Pressure.jmp" );
dt << Transpose( Columns( 2::6 ), By( :Dose ), Label( :Subject ) );

Stokes — Wed, 12 Oct 2022 19:44:24 GMT

Hi, Both solution works great