Extract column info from jmp tables

[#1]

Is it possible to extract column info like Column Name, Datatype, Coding and  Design role wothout having to manually right click on each column of a table and copying the data? Thanks for any help.

[#2 · Accepted solution]

Yes, check out the Scripting Index (Help > Scripting Index) under Data Table > Column Scripting.  The whole section with "Get _______" does the kind of thing you want to do.

 If you want to get everything in one function, you can use "Get Script" though you'll have to process the results a bit to get each component.  Probably easier to write your own function that returns the results of Get Column Properties, Get Name, Get Format,  and Get Modeling Type, etc.

[#3]

You can use

col << get property("<prperty>");

to get whatever information you want. 

You may be able to get the information you want by using the Column Viewer with it't "Find Columns with Properties".

Finally, one item I hae used is to use

dt << get script

It will detail all of the properties for each of the columns.  However, since it will also contain all of the data for the data table, I typically delete all of the rows in the data table, and then use the << get script. 

[#4]

Hi,

There is a wonderful table properties add-in written by @Justin_Chilton that will do exactly what you need.

Have a look at the add-in and see if will do what you want.

cheers,

--Stan