Add a csv to a JMP Data Table

mochar — Fri, 27 Mar 2020 23:38:29 GMT

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)

Re: Add a csv to a JMP Data Table

txnelson — Sat, 28 Mar 2020 02:28:45 GMT

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

topic Re: Add a csv to a JMP Data Table in Discussions

Add a csv to a JMP Data Table

Re: Add a csv to a JMP Data Table