Subscribe Bookmark RSS Feed

Transpose Label Column

ravi_jmp

Community Trekker

Joined:

Nov 3, 2011

I am transposing a data table with the below JSL script. In the output table, the label column name ends up as "Label" even though I am trying to set it to "XYZ". I tried Label Column Name ( "XYZ" ) also.

If I do it manually, specifying the label column name in Transpose dialog box, it works. But the 'Source' script of the output table doesn't have a Label Column statement.

Any ideas of how to do this in JSL?

Data Table( "Sum" ) << Transpose(

    By Columns (:Col2, :Col3, :Col4),

    Label( :Col1 ),

    Output Table( "Output" ),

    Label Column( "XYZ" )

);

2 REPLIES
ms

Super User

Joined:

Jun 23, 2011

Label Column Name ( "XYZ" ) works in JMP 10 but seems not to be supported in JMP 9.

ravi_jmp

Community Trekker

Joined:

Nov 3, 2011

MS, thanks for checking. I was using JMP 9.