369862_en-US

liliconcom

Transpose column, make transposed rows headers in JMP12

Does anyone know how to transform a column (just one column) and make the rows become the table header using JSL?

 

I am using JMP12.

Basically, I want the first row to be the column headers and not the output below. My dataset is attached.

 

 

 

Thanks,

Simon

dt = Data Table( "sports" ) << Transpose(
   columns( :Items ),
   Output Table( "transposed" )
   );

Data TableScriptingRe: Transpose column, make transposed rows headers in JMP12

Hi, I don't have JMP 12 loaded anymore but I think all of what I used here was around in JMP 12... give this a go.

 

Cheers,

Brady

 

p.s.--we've added a lot of cool stuff since JMP 12 !!

 

Names Default To Here(1);

//replicate your original table
dt = New Table( "sports",
 New Column( "Items", Character, "Nominal",
  Set Values( {"soccer", "volleyball", "7tennis", "basketball"} ),
 )
);


//get a list of desired column names.
colNameList = dt:items << get values; 

/*
If you're creating a new table: build a 1 row, n column matrix of missing data
with the J() function and the As Table() function, which lets you set column names
easily.
*/
newDt = as table (J (1, nitems(colNameList), .), <<COLUMN names=""></COLUMN>

 

 

Re: Transpose column, make transposed rows headers in JMP12

works like a charm.

 

Thanks a lot!