I want to group 30 columns of my data table into 2 group columns.
My script as below;
dt << group columns( "SeahawkDefects", :FBMissing Bond :: :SBBall Accuracy );
Current Data Table () << group columns( "TTDefects", :NU-No Unit :: :MP-Missing Phosphor );
I able to create the 1st group column (FBMissing Bond until SBBall Accuracy). But, when I use similar script to create the 2nd group (NU-No Unit until MP-Missing Phosphor) column, JMP error prompted Name Unresolved.
Why is that so? What should I do to create the 2nd group column? (I'm using JMP 15)
WebDesignesCrow_0-1647237260152.png
I'm not sure why the error prompted. But I created the 2nd group columns manually and view the table script.
When i changed the script like below, it works.
dt << group columns( "SeahawkDefects", :FBMissing Bond :: :SBBall Accuracy );
dt << group columns( :Name( "NU-No Unit" ), 15 );
The typical issue when you get errors like the one you got is that what you are thinking the "Current Data Table" is and what JMP thinks the "Current Data Table" is, is different. It is always a better coding practice to make absolute references to the data table you want to point to.
Therefore,
dt << group columns( :Name( "NU-No Unit" ), 15 );
is a better coding technique than
current data table() << group columns( :Name( "NU-No Unit" ), 15 );
The issue is that the columns NU-No Unit and MP-Missing Phosphor have a minus sign in them that JMP is trying to interpret. Hence you need to use the construct
dt << group columns( "TTDefects", :name("NU-No Unit") :: :name("MP-Missing Phosphor") );
I'm not sure why the error prompted. But I created the 2nd group columns manually and view the table script.
When i changed the script like below, it works.
dt << group columns( "SeahawkDefects", :FBMissing Bond :: :SBBall Accuracy );
dt << group columns( :Name( "NU-No Unit" ), 15 );
The typical issue when you get errors like the one you got is that what you are thinking the "Current Data Table" is and what JMP thinks the "Current Data Table" is, is different. It is always a better coding practice to make absolute references to the data table you want to point to.
Therefore,
dt << group columns( :Name( "NU-No Unit" ), 15 );
is a better coding technique than
current data table() << group columns( :Name( "NU-No Unit" ), 15 );
The issue is that the columns NU-No Unit and MP-Missing Phosphor have a minus sign in them that JMP is trying to interpret. Hence you need to use the construct
dt << group columns( "TTDefects", :name("NU-No Unit") :: :name("MP-Missing Phosphor") );
Thank you for the explanation.