Welcome to the JMP User Community!

Latest Discussions

• How to make an SQL table Invisible?

  I have another "invisible" question. I made an SQL table (from Query Builder) and want to modify my JSL to make that table invisible. I've tried adding "Invisible" to many different places, but none have worked. Is there a different syntax for making a Query Builder table invisible? Here is my code - thanks in advance for the help!dt1=New SQL Query( Version( 130 ), Connection( "JMP" ), ["JMP_Table...

  isabellet14

  Discussions |

  Jul 7, 2016 6:54 AM

  9532 views | 2 replies

• Importing SQL using a temp table

  I am having a difficult time using Stored Procedures and Temp tables in JMP 11.2.1.  I simply get no returndb = Create database Connection("DRIVER=SQL Server;  SERVER=localserver\SQLEXPRESS;  DATABASE=Test");Execute SQL(db,   "  CREATE TABLE #Test ( ID int)  Insert INTO #Test (ID)  VALUES (1), (2), (3), (4), (5)  SELECT *  FROM #Test  DROP TABLE #Test  ",  ":-(");close database connection(db);This...

  vince_faller

  Discussions |

  Jul 6, 2016 2:52 PM

  16682 views | 14 replies

• customize the formatting of the target excel file when save a data table as a excel file.

  I would like to ask JMP community to help me out on a custom way to export JMP table to excel.Part of my script need to export a JMP table to excel file.Ideally, I would like to customize the formatting of the target excel file when exporting. (with desired column width, row height, color, etc.)But so far, I find that JMP will only carry the cell color to the target excel file. And I’ve been looki...

  zlsas

  Discussions |

  Jul 6, 2016 11:26 AM

  9547 views | 3 replies

• Date does not replicated into JMP from Excel

  Hi All,Need help !Not very familiar with JMP & still learningAfter copy the data from excel & pasted into JMP, the date cannot get it correctly.Anyone can help to guide me ? Thank you

  tohalan

  Discussions |

  Jul 6, 2016 10:21 AM

  6836 views | 2 replies

• How to extract characters in occurrences of a certain character

  for instance, I have a string of "JN-36M-GRNNC", I would like to extract "JN", "36M and "GRNNC" by using formula. The length between "-" is not fixed, can vary. I found an example on how to do it in Excel, https://www.ablebits.com/office-addins-blog/2015/10/07/excel-find-search-functions/. I wonder how to do it in JMP.
  Thank you!
  

  jyw

  Discussions |

  Jul 5, 2016 9:15 AM

  10616 views | 2 replies