Community Manager
There's no Java API but the JSL New Table() syntax is the best way to create a file that will be a JMP data table when opened.
You can put a //! on the first line of your script and it will run automatically when the file is opened. In this way, it will "look" like a JMP data table when opened.
You can get a template for the the New Table() syntax to create a data table by examining the table script for an existing data table. You'll find the table script in the hotspot menu in the upper left of the data table.
Attached here is an example JSL file to show this. When you open the file it will run automatically and create a data table.
-Jeff
Try this to see how it will scale for you. This JSL will make a table of random data, some numbers, some strings. You should probably make it twice as big as you expect your data to be... The script then creates the script Jeff described above and re-imports the table. Two times are presented; the first is the creation time and the second is the re-import time. Below you can see 1,000,000 rows of 30 variables makes a 370MB text string that re-imports in 45 seconds. At the end, the compare tables platform verifies the result. For problems of this size you will need a 64 bit JMP most likely; a 370MB string is going to push the limits of a 32 bit JMP on windows.
start = Tick Seconds();
dt = New Table( "original", Add Rows( 1000000 ), );
For( i = 1, i <= 30, i++,
If( Random Integer( 1, 2 ) == 1,
x = dt << New Column( "c", Character, Formula( Substr( "abcdefghijklmnopqrstuvwxyz", Random Integer( 1, 20 ), Random Integer( 1, 20 ) ) ) ),
x = dt << New Column( "c", Numeric, Formula( Random Integer( 1, 999999999 ) ) )
);
dt << runformulas;
x << deleteformula;
);
stop = Tick Seconds();
Show( stop - start );
Wait( 1 );
text = Char( dt << getscript );
Show( Length( text ) );
Wait( 1 );
start = Tick Seconds();
dt2 = Eval( Parse( text ) );
stop = Tick Seconds();
Show( stop - start );
dt << Compare Data Tables( Compare with( dt2 ), Compare Data );
stop - start = 12.0166666666046;
Length(text) = 369241917;
stop - start = 45.1166666664649;
Compare Data Tables[]
