topic Re: How do I create another group of columns in JSL scripting in Discussions

How do I create another group of columns in JSL scripting

WebDesignesCrow — Fri, 09 Jun 2023 18:13:01 GMT

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)

Re: How do I create another group of columns in JSL scripting

WebDesignesCrow — Mon, 14 Mar 2022 07:23:58 GMT

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

Re: How do I create another group of columns in JSL scripting

txnelson — Mon, 14 Mar 2022 07:23:24 GMT

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

Re: How do I create another group of columns in JSL scripting

pmroz — Mon, 14 Mar 2022 19:24:16 GMT

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

Re: How do I create another group of columns in JSL scripting

WebDesignesCrow — Wed, 16 Mar 2022 06:52:24 GMT

Thank you for the explanation.