Hi JMP community, hope you can help me with this problem:
I have made a script that allows users to calculate 1x, 2x and/or 3x SD-values for several sample concentrations with a given (to be entered) factor. The 1x, 2x and/or 3x SD-values can all be chosen via 3 check boxes. This first part works perfectly.
Based on the selected amount of check boxes, the resulting data table gives a variable amount of columns that I would like to split into a new data table.
I tried to build a second script that splits the data table based on all SD-columns present (always starting from column 3) but without success. This is my script so far:
Names Default To Here( 1 );
dt1 = Data Table( "SD Calculation" );
//Get list of Column names
ColList = dt1 << Get Column Names();
//Split dt1 based on ColList
dt2 = Data Table( "SD Calculation" ) << Split(
Split By( :nomRP ),
Split( ColList[3] ),
Remaining Columns( Drop All ),
Sort by Column Property
);
The resulting splitted table looks like this and is missing most of the data:
This is what it should look like (I can only achieve this by specifying all column names, however, not all columns are going to be present in each table (it’s based on user selection):
When all SD calculations are chosen (±1-3 SD for 5 sample concentrations), 30 columns should be present.
The goal for my script:
nomRP values are: 50, 71, 100, 141 and 200 and 1-3x SD values can be calculated for each of those nomRP values. All the calculated results should be split in a new data table. With these data I want to build a figure in the Graph Builder showing ranges based on the calculated SD values.
Kind regards,
Pim.
-Edit: "SD Calculation" table added.