cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
mochar
Level III

Add a csv to a JMP Data Table

Hi all. I've looked around to see if there is a script that adds/imports a csv file while still keeping the old data.

 

My objective is to have a master JMP file. Then everytime I test a different device/different date, I would like it to be added to the master JMP Data table without overwriting it. I've seen code that meshes all csv files in a folder, but I would like it for just one csv file at a time. (All files have the same columns)

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Add a csv to a JMP Data Table

You are thinking too hard.  This is a simple straight forward task

names default to here(1);

dt = Open("<path to the master jmp file>);

dtNew = Open("<path to the new csv file>);

dt << concatenate( dtNew, append to first table(1));

dt << save(<path to the master jmp file>);
Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: Add a csv to a JMP Data Table

You are thinking too hard.  This is a simple straight forward task

names default to here(1);

dt = Open("<path to the master jmp file>);

dtNew = Open("<path to the new csv file>);

dt << concatenate( dtNew, append to first table(1));

dt << save(<path to the master jmp file>);
Jim

Recommended Articles