topic Import Column units into new table with JSL in Discussions

Import Column units into new table with JSL

lpatton — Wed, 22 Oct 2014 21:06:30 GMT

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?

Re: Import Column units into new table with JSL

Jeff_Perkinson — Fri, 28 Oct 2016 13:14:43 GMT

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

Re: Import Column units into new table with JSL

ezorlo — Thu, 21 Nov 2019 10:58:23 GMT

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

Re: Import Column units into new table with JSL

txnelson — Thu, 21 Nov 2019 14:35:04 GMT

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