Dear JMP Community,
I would like to rename a column/columns by position. I am creating a subset of a dataset and each time I run the code it counts up some column names. This makes it cumbersome to use this subset in subsequent code because the column names are always different.
dt is my big dataset
dt << select where( :ScreenCaption == "XYZ" ); //mark the rows in which ScreenCaption == "XYZ"
dt2 = dt << Subset( Output Table( "Subset" ), SelectedRows( 1 ), SelectedColumns( 0 ) ); //create the subset using marked rows
dt3 = dt2 << summary(
Group( :Lot ),
Mean( :Value ),
Std Dev( :Value ),
statistics column name format( "column" )
); // intermediate data table dt3 to calc statistical values
dt_joined = dt2 << join( with( dt3 ), by Matching columns( :Lot ) ); // join both intermediate data tables together
its in the dt_joined where the column name always changes due to taking in data from the Subset table.
I would like to then access dt_joined and change column name of column, lets say 2, to be a fixed name, to better access it subsequently.
Does anyone have an idea. Maybe I am also overcomplicating things I have the feeling.
Best, Henning