In this blog series about "JMP and Excel – A Never ending Story?" I spoke about importing spread sheet data, and described the first few typical challenges when importing data from spreadsheets (or sometimes also other sources). This time I will focus on dates and date formats, the third topic I listed in Part 2. Day and…
In the big data era we would like to have all data in e.g. databases, hadoop servers, or access it directly from streams. However, still many data is saved or written in spreadsheets, updated manually or automatically by machines, engineers, lab people or other kind of operators. In JMP it is easy to import any kind of…
There are really many great reasons to join the Discovery Summit Europe Online. However I want to highlight a session for practitioners interested in Design of Experiments. Please Register: JMP Discovery Summit Europe Online - Attendee Driven Q&A Session about DOE This session has no agenda, other than to facilitate the…
I just came around a question from a customer which I found worth sharing to the scripting community and those who would like to become part of it :) In any platform where you can select the columns to drag them into roles you have the option in these little red triangles (hot spots) to show a filter, which helps you to…
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. You are interested in predictive modeling and want to learn and/or share experiences, have questions about certain predictive modeling topics, or…
On a regular base I hear from JMP users, that they want to update the data table with the new data rather than creating a completely new data table. This can have a variety of reasons: you may have done some data cleaning or recoding already, want to keep your work and previous analysis saved to the data table, or you just…
Traditional data analysis in a batch environment often does and/or cannot take into account all data of the process parameters recorded over time. You then take the startin value, mean or end value and hope to find relationships between these values and your response. There is much space to miss information, e.g. variation…
Have you ever experienced an issue importing data from Excel or other sources? I bet you are not alone, at least I had mine. In my previous blogs Part 1 and Part 1 cont. I showed in general how to import spreadsheet data into JMP. Let’s now talk about typical challenges importing data I come across over and over again,…
In my previous blog post JMP and Excel - A Never ending story? - Part 1 I ended with an example importing spreadsheets with hierarchical headers and merged cells. This time I focus on importing a spreadsheet file with many worksheets as well reading multiple spreadsheets (laying in a specific folder) into JMP. I do not…
Note: Though JMP can read spreadsheet files both on Mac and Windows, with different tools than Excel, I refer in my posts to a windows machine and Excel. Some features will be related to newer versions (e.g. Excel Import Wizard was introduced in JMP 11, Importing Excel Colors in JMP 13). In my previous blog post JMP and…
It looks like you're new here. Sign in or register to get started.