User bd9576aea6
27-01-2011 00:08:54
Hello,
I am a new user to JChem. I know that it is possible to import sdf files into JChem for Excel with structures, ID codes, physicochemical features etc as well as assay data in an excel format. However, what I am really interested to know is if the software can append the assay data to the correct compound in the imported sdf files by matching up ID codes? In other words, do i need to manually insert the relevant assay data for each compound one at a time.
Thank you in advance,
Marie
ChemAxon 0e37943a96
27-01-2011 12:36:52
Hi Marie,
it is not yet possible, to merge data based on a common field. Walready have this feature request in our issue tracking system. We do not know yet, in which release we are going to implement it.
In the meantime, you could try to accomplish this with a 3rd party add-in:
http://www.ablebits.com/excel-lookup-tables/index.php
It should be possible, since we do not input any special objects for structures, we use only a simple function. We will later implement probably a similar functionality.
Best regards,
Tamas.