Welcome to the JMP User Community!

Latest Discussions

• Create a associative array from unique selected rows and row number

  Hi All, I have table in which I have selected rows where subject is science or Math (using select where function). Now I want to create associative array which stores the row number of all selected with unique entries of a particular column.After that I want to start a loop for all keys of the associative array. Which will subset the rows from key[i] to Key[i+1] for each value. For Example: Row_Nu...

  Rajat

  Discussions |

  Apr 17, 2020 5:34 PM

  5513 views | 4 replies

• Multiple file import update data table in place

  Hey,I'm using MFI to concatenate multiple .csv files from folder(folder gets new files dropped in it every day) for analyzing data in JMP. I have also prepared couple scripts for analysis and data cleanup but my problem is that every time I run script for MFI it opens up a new data table without my prepared scripts for analysis :(I wonder what is the way right way to update my current data table i...

  morussk

  Discussions |

  Apr 17, 2020 9:36 AM

  4457 views | 6 replies

• DOE to test taster's ability to predict color of candy (for kids)

  Dear JMP & Community,   During this time of being stuck at home with kids and working on school projects, I thought of running a "taste test" with my son who recently claimed that he could tell the color of a chocolate candy based on the color of the candy shell (it's a candy similar to that of M&M).   I'm not entirely sure how to set up the DOE because it doesn't quite fall under Choice or MaxDif...

  SDF1

  Discussions |

  Apr 17, 2020 7:59 AM

  7470 views | 11 replies

• How to merge Text/Character ?

  Dear Sir I try find the related discussion before, but it seems not easy.I would like ask how to  merge Char.A + Char.B in new column, thank you. Char.AChar.BMergeA01A.01B02B.02C03C.03D04D.04E05E.05F06F.06G07G.07       

  StevenChan

  Discussions |

  Apr 17, 2020 7:49 AM

  4248 views | 3 replies

• how to use contains within match?

  I have some text in a listA.I want to create another listB based on the value in listA.If the listA text contains apple then list B should be fruit;if list A has tomato listB should be vegetable;if listA has daisy listB should be flower.If none of these match then listB should have unknown.Also search needs to be case insensitive. Looking for something equivalent to case statement in JMP.I'm explo...

  ENTHU

  Discussions |

  Apr 17, 2020 5:43 AM

  4351 views | 6 replies