Welcome to the JMP User Community!

Latest Discussions

• Iterate Through Data Table to Select Matching Items in Another Data Table

  Good Morning All, I am trying to create a script which will iterate through two columns on one data table and select all of the matching characters on another data table to perform a simple bivariate graph. To help visualize, consider me trying to iterate through Little Class.JMP by Sex and Name and select all matching rows on Big Class.JMP, then for each iteration, graph height by weight.

  Ksrzg01

  Discussions |

  Sep 22, 2022 12:34 PM

  7909 views | 9 replies

• How do I use a relative folder path in multiple file import?

  Members of my group use a Sharepoint workspace that includes raw test data that we'd like to import and process in JMP. Our shared script for processing that data is stored within the Sharepoint workspace itself, which seems to present problems for defining the folder path for the multiple file import function. It seems that Microsoft defines the path for a mounted Sharepoint or OneDrive folder as...

  alan_h

  Discussions |

  Sep 22, 2022 11:03 AM

  1618 views | 3 replies

• How to concatenate rows in a given column to a string in JSL?

  If I have a datatable dt with one column col1 and several rows containing characters e.g. a, b, c, d i.e. one character per row. How do I get a string of the form myString = 'a','b', 'c', 'd' ? If I do this  x = Associative Array( dt:"col1" ) << Get Keys; show (x);it gives me  x = {"a", "b", "c", "d"};whereas I would like to get a string myString = 'a', 'b', 'c', 'd'to use further in my next line ...

  Neo

  Discussions |

  Sep 22, 2022 9:59 AM

  956 views | 1 replies

• How to recode a column with a formula in JSL

  I am having trouble getting my recode script to run correctly. I have a data table with a column called DEPT which contains a number which corresponds to a specific departent name. What I want to do is create a new column called Dept Name that takes the values in DEPT and converts them to the written department name rather than the numeric version. This table is part of a larger script that I run ...

  rfeick

  Discussions |

  Sep 22, 2022 9:06 AM

  12905 views | 5 replies

• Why is a cell in a new row blocked with an "X"?

  Hi all, while manually entering a new row into a data table the corresponding cell in the third column immediately is blocked with a black "X". See attached photo. Any idea as to why this is happening? I closed all graphs associated with the data table. The first two columns are scroll-locked for easy viewing which is the only thing I notice that might be a factor. It looks like a number can be en...

  jmv

  Discussions |

  Sep 22, 2022 6:37 AM

  992 views | 2 replies