Learn JMP

Data Access

• Quickly See Which Data Table is Active

  When you have several data tables open, it can be hard to tell which one is active. In the Window List, the active data table is bold. Below, you can see that Big Class is the active data table. Window List Showing Active Data Table

  ruthhummel

  JMP Tips |

  Oct 11, 2023 1:26 PM

  239 views | 0 replies

• How do I Connect to OSIsoft PI Server?

  To import from the OSIsoft Pi Server, you must have the PI Web Server deployed and running and the PI Asset Framework installed and configured.   See how to open the JMP OSIsoft PI interface introduced in JMP 17, connect to the server by identifying the server url, authenticate if necessary, set the server name and database to which you want to connect, and then identify the Attributes (tags) you ...

  yasmine_hajar

  Learning Center |

  Aug 4, 2023 9:52 AM

  2119 views | 1 replies

• Excel Import Hands-on Activities

  These hands-on activities allow you to practice importing data from Excel into JMP using the Excel Import Wizard. The data files for the activity are in the zip file attached to this post. Extract the data in Excel Import Hands-on Activity.zip for use in the following activities. Click this link for the solutions. A PDF file of these activities and solutions (in English) is attached to this post. ...

  Di_Michelson

  Hands-On Activities |

  Jul 28, 2023 8:30 AM

  2633 views | 0 replies

• Excel Import Hands-on Activities Solutions

  These hands-on activities allow you to practice importing data from Excel into JMP using the Excel Import Wizard. This post contains the Excel import hands-on activities, the data, and a PDF file of these solutions in English.   1. Import the data from the file Practice 1.xls into JMP. Your table should look like the following screen capture when finished. a) Select File > Open. b) If needed, cha...

  Di_Michelson

  Hands-On Activities |

  Jul 28, 2023 8:30 AM

  1434 views | 0 replies

• Powerful Tools for Data Management

  In any analysis problem, most of your time is spent preparing the data for analysis. JMP makes this process easy with powerful data manipulation capabilities. See how to use JMP 17 or JMP Pro 17 to import data from PDF, JSON and text files; add spec limits as a column property; rearrange data; recode problematic values; and filter and graph data. Mac demo: (view in My Videos) This is part of the G...

  Laura_Higgins

  Learning Center |

  Jun 20, 2023 2:37 PM

  1949 views | 0 replies

• JMP Tips and Tricks for Everyone

  Get useful tips and powerful tricks to make the most of JMP and JMP Pro.   Windows demo: (view in My Videos)   Resources JMP User CommunityJMP Newswire JMP Blog Mastering JMP Live Webinars Mastering JMP Videos JMP Documentation (jmp.com/help) Link to Data Table Tools Add-in This is part of the Get Going with JMP series.

  Valerie_Nedbal

  Learning Center |

  Jun 14, 2023 6:16 AM

  3463 views | 2 replies

• How do I import time series data stored in OSIsoft PI Server? ( New in JMP 17)

  Data analysts who need access to time series data stored in an OSIsoft PI Server can use the File > Database → Import from OSIsoft PI Server path to import three types of data:   Raw: raw data points with timestamps that reflect when the data were recordedPlot: data points that have been interpolated based on a set of timestamps and is suitable for plottingInterpolated: data points that have been ...

  gail_massari

  Learning Center |

  Dec 14, 2022 4:58 PM

  1376 views | 1 replies

• Getting Started with JMP

  This is an ideal introduction to JMP for the new user or as a refresher for the infrequent user. This topic covers the basics of the JMP interface and data tables, getting data into JMP, doing basic summary analysis and charting, saving and sharing your work, and where to get help on JMP.   (view in My Videos)   Additional details can be found in the JMP Documentation - Discovering JMP.    This ...

  Chris_Kirchberg

  Learning Center |

  May 16, 2022 11:52 AM

  8394 views | 0 replies

• Excel and Automation

  See how JMP automatically captures actions as JMP scripts (JSL) and how you can easily edit these interactively to automate analyses.     Example: Workflow Automation (Also avaiable as separate video.) After we use the Excel Import Wizard to import data, we can use the associated script that JMP provides for the sequence of steps we followed during and after import.In JMP 16 and later, use the E...

  Laura_Higgins

  Learning Center |

  May 16, 2022 11:51 AM

  1718 views | 0 replies

• Get Going with JMP: Essentials for Using JMP

  These videos provide JMP essentials for new users and those who want a refresher.    Overviews Getting Started With JMP JMP Tips and Tricks (JMP 18)Better JSL Smoother Migration: How To Fix Your Own Code​   Automating Your Analysis WorkflowWhat’s New in JMP 17 Data Preparation From Excel to JMP: Importing, Consolidating and Maximizing the Value of Excel Data NEW! Formulas and the Formula EditorPow...

  Laura_Higgins

  Learning Center |

  May 11, 2022 10:30 AM

  9261 views | 0 replies

• Using the Excel Import Wizard

  (view in My Videos)   Using the JMP Excel Import Wizard   In JMP 12 for Mac and earlier versions of JMP for Windows, opening a Microsoft Excel file launches the Excel Import Wizard.   The Wizard is especially helpful when the structure of Excel data is irregular.   For example, you might want to exclude columns or convert the text in the third row to JMP column headings.   To open a Microsoft E...

  ryandewitt

  Learning Center |

  Mar 24, 2021 5:21 PM

  5279 views | 1 replies

• Importing PDFs - PDF Import Wizard

  (view in My Videos)     The PDF Import Wizard enables you to preview a PDF file, adjust the import settings, and view the results in the data table preview before you import the data. And to ease this process, JMP will attempt to auto-detect the data structure in the PDF file, or you can customize the structure.   Let me quickly demonstrate this by importing a PDF and Concatenating a table with t...

  ryandewitt

  Learning Center |

  Jul 10, 2020 7:28 AM

  2897 views | 0 replies