topic Re: Extract column info from jmp tables in Discussions

Extract column info from jmp tables

powerpuff — Fri, 02 Mar 2018 20:48:23 GMT

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.

Re: Extract column info from jmp tables

cwillden — Fri, 02 Mar 2018 21:23:46 GMT

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.

Re: Extract column info from jmp tables

txnelson — Fri, 02 Mar 2018 21:38:07 GMT

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.

Re: Extract column info from jmp tables

stan_koprowski — Fri, 02 Mar 2018 21:37:03 GMT

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