nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can files in JMP format achieve the function of extracting files without opening files or appending

lwx228

Hello, everyone!
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!

Accepted answers

All comments

lwx228

The new data files to be added should be:

Craige_Hales

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" );

several rows added, several times

lwx228

Thank Craige!
Nor do I intend to extract and append data at the same time.

But I can't understand the method you provided above.

Now let's take appending new data to file "Big Class.jmp" as an example.
Thank you very much for your continued guidance.

lwx228

I am not familiar with how JMP USES SQL methods.