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
In this video, we show how to create tabular summaries for the Impurity data. We use Tabulate to create summary statistics for Impurity for the different reactors and shifts.