Welcome to the JMP User Community!

Latest Discussions

• Copying Columns, Column Names and Table name to a New Table

  Hello,I'm having a bit of trouble copying columns from multiple data tables into new blank table. The data tables to be opened all have the same column names. So far, I can open multiple tables but can only copy columns from one the latest data table opened.Here is my code below:Names Default To Here( 1 );// Use 'PickFile()' to get a list of files to open (Windows only)fileList = Pick File(       ...

  luqi

  Discussions |

  Feb 9, 2016 8:56 AM

  12735 views | 6 replies

• Proper syntax to call Formula within Loop

  Hi, I would like to quickly enter multiple columns with the same overall formula but different variables.I have tried the following but clearly, I'm not using the proper syntax to call the Fomula item in the New Column function:Names Default to Here (1);dt = Current Data Table ();cc = N col (dt); // Retain the original column numberFor (i=9,i<= cc, i = i+2,  New column ("Delta " || Column Name (i+...

  sornasst

  Discussions |

  Feb 9, 2016 8:48 AM

  10027 views | 3 replies

• Clone a Table

  What are some of the ways you guys clone a table?  Is there an easy way to make the tables talk?  Say, changing a value in a cell will update both tables?

  msharp

  Discussions |

  Feb 9, 2016 8:25 AM

  14944 views | 6 replies

• Byte Array Image from Database to JMP

  Hello everyone,we have a tricky problem. We have some images in a database stored as a byte array. Using SQL, we want to get those byte array images from the database into a jmp data table (or picture box).First of all, is this even possible? And if yes,  a little sketch of how to do this would be highly appreciated. Right now, we have no idea of how to start...Thank you very much!

  vkessler

  Discussions |

  Feb 9, 2016 7:40 AM

  28326 views | 6 replies

• How read BLOB datatype from Database into JMP and transform it to generate image?

  I am trying to read the BLOB data present in database and transforming it to generate image. The data table when imported into jmp shows the BLOB field as empty. The blob field is stored in the database correctly

  zainilmin

  Discussions |

  Feb 9, 2016 5:42 AM

  10326 views | 3 replies