Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
I have been searching the boards to see how to bring in all rows of a data set through a query. But when I run the query it only returns the first three rows of data. I know it is probably a simpe solution to this but havent been able to find. Any help with this would be greatly appreciated.
This may not apply to your setup, but if using JMP for Macintosh and the trial version of Actual Tecnologies ODBC-drivers, any query would only return the first three rows of data. Only after licencing the driver one can get all rows.