Welcome to the JMP User Community!

Latest Discussions

• JSL: get unique values of a data table column

  Hi,
  
  I currently use the summary command to get unique values of a data table column, which in my opinion is too complicated for that simple task. I think there has to be a simpler command that works on a data table column or a vector, but I cannot find one. Am I right?
  
  My current code looks like this:   // sample data set: dt = New Table( "dt" ); dt:"Column 1" << setvalues( [1, 1, 2, 7, 7, 4, 5, 1, ...

  

  Discussions |

  Nov 12, 2021 8:37 AM

  39175 views | 9 replies

• how can i export or save the smoothing in a table.

  Hey people,
  I have a plot of 12000 values ​​here and can show the smoothing in the graph, but I would like to export this smoothing as a table (values) so that I can later calculate the integral.
  how can i export or save the smoothing in a table.
  thanks

  oliver21

  Discussions |

  Nov 12, 2021 6:26 AM

  2718 views | 3 replies

• Import Multiple CSV Files from different folder, Update Value, and save CSV with different names

  I have about 95 csv files with different column names saved under main data folder and 95 different sub-folders like \data\dataset1\dataset1.csv, \data\dataset2\dataset2.csv, etc. id1 and id2 columns are common variables across all files. I want to to do the following:Import all 95 csv files to JMP (using JMP Pro 16)Update a value based on a condition across all 95 files: if (id1 = 'a001' then id2...

  Helal

  Discussions |

  Nov 12, 2021 5:51 AM

  3489 views | 4 replies

• Is it possible to make relationship between two columns in a data filter easier to see?

  Hi everyone, I think this is simple question; hopefully with a simple answer, that just takes a minute to explain. When I have more than one column that is being used in a data filter I can use the red triangle menu to independently select (for each column) the relationship among levels (e.g., "match any", "match all", etc.). I'd like to have a similarly persistent and visible option for configuri...

  caseylott

  Discussions |

  Nov 11, 2021 12:27 PM

  2355 views | 2 replies

• Is it possible to make a data filter wider (instead of taller) as more filtering columns are added?

  Hi again. Here is a second data filter configuration question... I'd like to use a relatively large number of categorical columns as data filters. Some of these have many levels. Currently, each time I add a column to a data filter it is appended below the last filter. This results in an impractically tall chain of filters that scroll well off the page (and don't compact well with scroll bars). In...

  caseylott

  Discussions |

  Nov 11, 2021 11:57 AM

  3115 views | 4 replies