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

Automation and ScriptingData Blending and CleanupDesign of ExperimentsMass CustomizationQuality and Process EngineeringRe: Transpose column, make transposed rows headers in JMP12

Thanks @txnelson 

Re: Transpose column, make transposed rows headers in JMP12

@brady_brady probably provided you with better solutions, but if all you want to do, is to create an empty data table where the column names are the value from the first row, the following will do a real simple job of that

dtNew = Data Table( "sports" ) << Split(
 Split By( :Items ),
 Split( Transform Column( "Transform[Items]", Nominal, Formula( . ) ) ),
 Sort by Column Property
);
dtNew << delete rows(1);

 

Re: Transpose column, make transposed rows headers in JMP12

works like a charm.

 

Thanks a lot!

Re: 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>