nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filtering Databases (Exhausting Subsets)

unknown

Greetings,

I'll keep it real simple and easy, just a home run swing for the JMP gurus on the board!

I'm trying to write a JSL script where I click on a column, run the script, and a subset table is created for each of the values in the field. (The field can consist of either numbers or text).

Thanks!

Accepted answers

All comments

XanGregg

One idea is to make a summary table and then make a subset for each row in the summary table.

unknown

Awesome!!! This is fantastic.

Thank you so much!

unknown

Suppose I wanted to name the subset table after the value for which it is filtering. I've defined a new line of code in the 'for loop' that should get the r(th) row from the summary table, but it isn't working for some reason.

(I haven't figured out how to post code correctly, so I'll paste it in two parts, starting with defining the data tables, then the for loop:

dt = Current Data Table();
If( N Items( dt << Get Selected Columns() ) != 1,
Throw( "select a column first" )
);
dtsum = dt << Summary( Group( dt << Get Selected Columns() ) );
dt << Clear Column Selection();

unknown

I can't get the script to paste on here, but I added the line:

tt = dtsum<

XanGregg

Use to escape JSL code.

You should be able to set the table name in the subset command, but I haven't tried it.