cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
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