Extract column info from jmp tablesIs 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.
Re: Extract column info from jmp tablesHi,
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
Re: Extract column info from jmp tablesYou can use
col << get property("<PRPERTY>");</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.
Re: Extract column info from jmp tablesYes, 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.
