How to export make binning formula script in JSL

aaronjiang — Tue, 02 Jul 2019 17:27:15 GMT

I am able to use make binning formula for my datasets. But I want to export the script that enables the binning to happen. Does anyone know how I can achieve that?

Re: How to export make binning formula script in JSL

jules — Tue, 02 Jul 2019 18:04:04 GMT

Hi @aaronjiang,

When you use Make Binning Formula, a new column is created with the formula used to make those bins. You'll see in the columns list on the left that the binning column has the plus sign next to it -- that means there is a formula for that column.If you click that plus sign, or right-click the column header and select Formula, you can see the formula that JMP has written for you. If you double click that formula, you can see the JSL:

You can use that jsl in another formula column in another table if you want, so long as that table has the same column name you used in your original table. If you wish to copy the jsl to create the column and apply that formula, you can use the Copy Script For Selected Column(s) to Clipboard Add In.

If you would like more details on JMP Formulas in general, I suggest you watch one of the Mastering JMP Webinars. I suggest Using Formulas to Get the Most from Your Data

I hope this helps!

@jules

topic Re: How to export make binning formula script in JSL in Discussions

How to export make binning formula script in JSL

Re: How to export make binning formula script in JSL