Welcome to the JMP User Community!

Latest Discussions

• Change Column Name after performing Summary Function

  Hello.Good day.Team,I will be needing your support on how to achieve my target table output.I have a sample data table. I made a Mean Summary for Group 1 and Group 2 Columns, separately.But i want to combine the two Mean Summary table into 1 table.However, since Group 1 and Group 2 has different Column NameDuring Concatenate this 2 Columns will have separate Columns.In order to have them in same C...

  karem

  Discussions |

  Sep 17, 2013 12:56 PM

  3949 views | 1 replies

• 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