How to Save Queried Data Table to a Specified Folder through script?</CODE></PRE><P>Hi! Does anyone here knows how to save a queried data table to a specified folder through jmp script? Can't seem to find the right way in doing it... Thanks in advance!</P><P>Here's my sample script:</P><PRE><CODE class=" language-jsl">Data Table( "name of data table" );
//save raw data table to a folder
dt = current data table ();
filepath = "C:\Users\folder path";
dt<< save(filepath || "name of data table.jmp");
Data TableScriptingRe: How to Save Queried Data Table to a Specified Folder through script?I suspect the issue is that there is a "/" missing between your filepath and "name of data table.jmp". Below is a working script that
Names Default To Here( 1 );
Open( "$SAMPLE_DATA\big class.jmp" );
dt = Data Table( "big class" );
filepath = "$TEMP";
Wait( 5 ); // placed for the example so the table will be visible
dt << save( filepath || "\" || "mytable.jmp" );
Close( dt, nosave );
Wait( 5 ); // placed so for the example one can see the table is closed
Open( filepath || "\" || "mytable.jmp" );
