Updating a JMP data table from a spreadsheet made easy - Part 1
Get your current JMP data table updated with new data from a (vertical structured) spreadsheet, preserving your made changes in the current data table.
Get your current JMP data table updated with new data from a (vertical structured) spreadsheet, preserving your made changes in the current data table.
Join us on Monday 20 March, 13:00-16:00 CET, for this lightly structured discussions to share your ideas, ask your questions, get answers, and learn more about Design of Experiments in JMP.
Almost all platforms in JMP have the same structure in the platform window, and selecting columns can be hard if you have many. Good thing you have a filter in the hot spot.Now you build your own application and you want to have this filter opened as default - how to do so?
Submit your predictive modeling feedback here Europe’s JMP 2021 Discovery Conference has gone virtual with that we are excited to announce the first European Predictive Modeling Unsession, which will take place on March 8!
Get your current JMP data table updated with new data from a (horizontal structured) spreadsheet, preserving your made changes in the current data table.
Understanding early in a batch process if the yield fullfills your requirements is critical to avoid plenty of waste and lost time. Take a look how the Functional Data Explorer in JMP Pro (as of version 14) can help you!
The title probably better would have been "Dates - a never ending story". Read how you can avoid or work around challenging situations with date values.
Be aware of data issues making importing data a challenge, if not a nightmare. I will talk about typical issues, from two year digit rules to decimals and commas - a very common issue in non-US countries.
Spreadsheets are often used to gain better overview of the data. This leads to structures hard to do statistics with. Learn how to read non-trivial structured data from spreadsheets into JMP. This time when multiple worksheets as well spreadsheets have to be imported. Note: Though JMP can read spreadsheet files both on Mac and Windows, with different tools than Excel, I refer in my posts to a wind...
Data Structure and Data Import Spreadsheets are often used to gain better overview of the data. This leads to structures hard to do statistics with. Learn how to read non-trivial structured data from spreadsheets into JMP.
Excel sheets are still a common source of data. For analytical purpose JMP users know better tools, but how to make good use of JMP’s functionalities if the data is in a shape that is not easy to import. How to handle different structures, multiple sheets in one table, different date formats, localization challenges and similar?