Take Big Class.jmp as an example, whether JSL can achieve the following functions:
1. Add new data for each column in the last row of file Big Class.jmp without opening Big Class.jmp.
2. In the case that Big Class.jmp is not opened, can the data of each column aged 13 and weighing between 90 and 100 be extracted?
It's like a database function.Thanks!
The new data files to be added should be:
JMP data tables are designed to be read and written from JMP. They are loaded into memory, modified, and saved. Two users can't do that at the same time; the second person that saves will overwrite the first persons changes.
You can use JMP's SQL support to do what you describe.
dbc = Create Database Connection( "DSN=homedb" ); dt = Execute SQL( dbc, " INSERT INTO stories ( name, story, grade) VALUES ( 'aaa', 'ddd', '98' ), ( 'bbb', 'eee', '97' ), ( 'ccc', 'fff', '96' ); " ); Open Database( "DSN=homedb;", "SELECT * from stories", "stories" );
I may have misunderstood your question.
You can use JMP to open a table, add rows, delete rows, select rows, make subsets, save the table.
You can't do that without opening the table.
SQL is a query language for a database.
Databases may be more than you need (big learning curve ahead).
What problem are you trying to solve?
What sort of process generates your data, JMP or an external program?
How many rows and cols do you anticipate?
What speed requirement do you have?
Try making a test table and see if open/add rows/close can meet your requirement.
What analysis will you be doing? Does it need all the data? Can the append and the analysis be done with a single open?