Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
lpatton
Level I

Import Column units into new table with JSL

I am created a summary table using JSL script from an original data table.  Is there an easy way using JSL script to import all of the column properties from the original table (such as units) to the new summary table?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: Import Column units into new table with JSL

This is similar to the Copying column properties from one data table to another discussion.

You can use the Get Column Properties and Add Column Properties messages to get them from the source table and set them in the target table.

-Jeff

-Jeff

View solution in original post

3 REPLIES 3
Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: Import Column units into new table with JSL

This is similar to the Copying column properties from one data table to another discussion.

You can use the Get Column Properties and Add Column Properties messages to get them from the source table and set them in the target table.

-Jeff

-Jeff

View solution in original post

Highlighted
ezorlo
Level III

Re: Import Column units into new table with JSL

Hi,

When I make a summary table from the tabulate option, the units from the column do not show up in the table. Only the column label is displayed. 

I could write the units by hand into the column label but I wonder if there is a more elegant solution?

 

Thanks

Highlighted
txnelson
Super User

Re: Import Column units into new table with JSL

The column's units are not part of the column name.  They are a separate column property, called "Units".  What you need to do, is to go to the newly created data table.  Then right click on the column header and select

     Column Properties==>Units

Type the units into the dialog box that is displayed, and then click on OK.

The Units will then be displayed at the end of the Column Label

units1.PNG

units2.PNG

units3.PNG

 

Jim
Article Labels

    There are no labels assigned to this post.