254714_en-US

liliconcom

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)

 

 

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="">);</PATH></PATH></PATH>