Welcome to the JMP User Community!

Latest Discussions

• How to filter a dataset using a separate dataset with 1000s of IDs (subquery, scripting)

  I have a "BIG" dataset containing several million rows. Each row has a specific IDENT field. IDENT may occur multiple times. I have another, smaller dataset "SMALL", that contains just hundreds of 1000s of rows. Each row has also a specific IDENT field.   Now I just want to keep all the rows from BIG, that have the same IDENT in SMALL. In other words: How to filter BIG using the IDENT field from S...

  Newbie2Jumpie

  Discussions |

  Jul 15, 2019 5:10 AM

  4550 views | 4 replies

• Deleting specified rows

  Hey JMP community, I am extremely new to jmp/jsl (literally just started this week). I have a script that is supposed to select where certain values in a row are less than 3, and then delete those rows. This is the script I have to do so:   dt << select where( :Residual 1 <= 3 ); dt << delete rows;   The code correctly selects the rows I want it to, but upon deleting the rows they "update" themsel...

  kcorder

  Discussions |

  Jul 12, 2019 9:42 AM

  3698 views | 2 replies

• Save file to network

  I'm working on a project that will take some data and export a csv file. I got it to save successfully to the local drive but I was wondering if there is a way to have it save to a different network drive, and what I would need to do this. Thanks

  DRemd

  Discussions |

  Jul 12, 2019 9:04 AM

  2571 views | 3 replies

• Custom DOE with Disallowed Combinations Scr

   Hi, I have 5 factors for a custom DOE and I need two linear constraints:Mean(CAP + RAP + OAP + EAP) + 10 < RRP
  Max(CAP, RAP, OAP, EAP) - Min(CAP, RAP, OAP, EAP) < 150It is ok for CAP, RAP, OAP, EAP and RRP to vary significantly between 100 and 500, but if they vary, I want them to be somewhat close together. For example 450,400,350,450,500 is ok, but 100,500,100,500,500 is not. I've tried the belo...

  PS

  Discussions |

  Jul 12, 2019 12:49 AM

  7135 views | 9 replies

• JSL for exporting/saving JMP Data Table as a CSV file without saving the Column Headers

  Hi Experts!I need some help on some JSL, as stated in the subject of the discussion:JSL for exporting/saving JMP Data Table as a CSV file without saving the Column HeadersAppreciate the help.Thanks in advance!regards,ambs

  ambs

  Discussions |

  Jul 11, 2019 4:58 PM

  20779 views | 4 replies