I have a question about using JMP to select only superceded data from a db.
This is an example of a query that illustrates my dilemma:
"SELECT Top 3 * FROM (db)
WHERE TrackOutTime> '1/1/2018'");
It works, but t I have many of the same wafer IDs with multiple entries, and I'm intereseted in only getting the most recent entry.
The example query gives me a table like this:
How do I make my query select only the most recent wafer ID entry?
What database are you trying to query?
Different databases use different syntax for the type of query you are trying to perform.
Without all the details I think you might be able to do something like the following--
This will limit or return the first 3 rows.
Or you could always use the custom SQL function.
Go to the red triangle menu and select convert to Custom SQL.
I'm sorry I did not responds sooner. I tried to understand this reply, but it is too advanced for my current coding skill level and was not able to implement. I had asked a few people here to help me, and they broke down the code for me. I still don't necessarily understand, but it seems like it's similar to what you have done, and I appreciate you taking the time to answer my question.
The graphical interface you displayed is very much different from what I am accustomed to using, and seems much more functional than my neanderthal methods. If there is some class I can take to get more familiar with that interface I'd be interested in persuing it, but I would not even begin to know where to look, where to start, or what to request in order to get some introductory/novice level exposure.