Append a transformed variable to a col list box

anne_sa

Hello everyone,

 

I can't add a transformed variable to a col list box when I use the "Append" function.

 

Here is an example:

 

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
New Window( "Col List Box Example 3",
       H List Box(
             ll1 = Col List Box( all ),
             Button Box( "Add", ll2 << append( ll1 << get selected ) ),
             ll2 = Col List Box( "numeric", MaxItems( 1 ), nlines( 1 ) ),
             Button Box( "Remove", ll2 << remove selected )
       )
);

 

 

Then for instance I right click on the variable "height" > "Transform" > "Log"

 

When I select the new variable "Log[height]" and click on the "Add" button nothing happen...

 

Do you have any idea of how I could change that?

 

Thanks in advance for your help!

Wendy_Murphrey

Hello,

 

Unfortunately, there is no JSL support for transformed columns in ColListBox at this time.  The suggestion has been submitted to the JMP Development team for consideration in a future release.

 

In the meantime, you could add a check to verify that the column exists.  If it does not, then put up a message to instruct the user that transformed variables must be added to the data table.  To do so, right-click on the transformed column and select Add to Data Table.

 

 

New Window( "Col List Box Example 3",
  H List Box(
    ll1 = Col List Box( all ),
    Button Box( "Add",
           colList = dt << Get Column Names( String );
           If( Contains( colList, (ll1 << Get Selected)[1] ),
               ll2 << append( ll1 << get selected ),
               Caption( "Transformed variables must be added to the data table" )
           );
    ),
   ll2 = Col List Box( "numeric", MaxItems( 1 ), nlines( 1 ) ),
   Button Box( "Remove", ll2 << remove selected )
  )
);

 

 

I hope this helps.

 

Wendy