Subseting a jmp table using a .csv list of serial numbers

MooMinIL

Hey,

I'm a bit of a novice to JMP and have been using mostly the GUI aspect of it, not much scripting so far, but I've come to a point where I can't find a way to perform my task using just GUI.

I've got a big jmp table with many columns. One of those is a SerialNumber column that contains strings (the sn can be both characters and letters) and I have a seperate list of serial numbers that stand out. I would like to get a subset of the original table according the the serial number list (which can be quite big itself, so entering manualy is obviously out of the question).

 

What would be the prefered plan of action to achieve such a subset in jmp? I couldn't find anything about using an external list to subset my data when googling...

 

Jeff_Perkinson

You can do this interactively (no scripting) by importing the .CSV into a JMP data table and then use Tables->Join to join by matching serial number. The resulting table wil be only the serial numbers that occur in both tables.