Welcome to the JMP User Community!

Latest Discussions

• JMP needs ODBC Driver to Open Excel Files

  I just upgraded to JMP 11 yesterday. I cannot open Excel files. Doing a Google search I figured out I needed an ODBC driver. I have tried the actual technologies driver, to no avail. the OpenLink website is very confusing. They offer multiple drivers depending on what database you need to get access to. I don't know if Excel is an access database, MySQL, SQL Server or what. I am running JMP on a M...

  atlas100

  Discussions |

  Sep 12, 2013 11:41 AM

  6992 views | 4 replies

• JSL code for File Open if file exists

  Hi Folks,I have some JSL code that opens a series of files (both a *.jmp and *.dat) and then performs various data management activities on them (namely, testing for presence of new data and then concatenating only the new data). The code runs fine as long as all the files are present.  There are some cases where a particular data file hasn't been collected and I want the JSL code to run for those...

  terapin

  Discussions |

  Sep 12, 2013 7:27 AM

  14345 views | 2 replies

• Create Associative Array from Column Values

  I would like to create an associative array from column values.  I am curious if anyone in the JMP community has a clever solution.  I am using JMP10.  An example is below.// For the following data table:example = New Table( "Example Data", Add Rows( 27 ),  New Column( "Lot", Character, Nominal, Set Values( {"A", "A", "A", "A", "A", "A", "A", "A", "A", "B", "B", "B", "B", "B", "B", "B", "B", "B", ...

  robot

  Discussions |

  Sep 10, 2013 11:05 AM

  10385 views | 2 replies

• How to use JSL to repeat a sequence to the end of a data table?

  I have a set sequence that I want to repeat to the end of a data table like you can do with the "Fill to End of Column" when you select rows where this can go on for an unspecified number of rows   I'm using the following:   NewColumn("Part", Character, Values({"1-B","1-B","1-B","1-D","1-D","1-D", "1-F","1-F","1-F","1-H","1-H","1-H","1-J","1-J","1-J","1-L","1-L","1-L", "2-B","2-B","2-B","2-D",...

  cmjewart

  Discussions |

  Sep 6, 2013 4:08 PM

  12434 views | 1 replies

• Contour plot algorithm?

  Can someone point me to a reference that describes what function JMP uses to define the contours on the Contour Plot platform?  I found this in tech help: JMP uses a method of triangulation and linear interpolation to generate the contours in the Contour Plot where a combination of three data points are used to generate a triangle. To see the triangulations, opt to "Save Triangulations". but is th...

  dzeke

  Discussions |

  Sep 6, 2013 10:57 AM

  9223 views | 1 replies