topic Re: how to exclude specific columns with list in Discussions

how to exclude specific columns with list

GoSook — Tue, 14 Aug 2018 01:24:53 GMT

I have too many columns, so I grouped the columns into several lists.
I want to see only few groups and I’ll exclude others.

Using sinply for-loop takes too much time, how can I do?

Re: how to exclude specific columns with list

txnelson — Tue, 14 Aug 2018 02:01:31 GMT

Are the lists of columns you are referring to, actual JMP LIsts structures from JSL?

Have you actually grouped the columns into JMP column groups?

Is the issue that you are "Hiding" the lcolumns, so you can only actually see a specific set of columns?

I would like to see more specifics on what you are attempting to do.

Re: how to exclude specific columns with list

GoSook — Tue, 14 Aug 2018 03:28:43 GMT

Are the lists of columns you are referring to, actual JMP LIsts structures from JSL?

> I have list that involve column names of data table.
ex:
var1 = {“weight”, “height”}

Have you actually grouped the columns into JMP column groups?

> not yet. I have just lists

Is the issue that you are "Hiding" the lcolumns, so you can only actually see a specific set of columns?

> yes, I want to hide some of the colunms from <filter col selector>

Re: how to exclude specific columns with list

txnelson — Tue, 14 Aug 2018 03:47:03 GMT

I suggest you look into the Column Grouping. It would allow you to handle what seems to be an overwhelming number of columns. The example below is based upong the Semiconductor Capability data table from the JMP Sample tables. Please note, by default it only displays the group title in the filters, unless you exspand the list by clicking on the triangle to the left of the group name.