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" )