| Re: Comparing two databases by merging [message #2228 is a reply to message #2226] |
Fri, 21 June 2024 10:05   |
thomas
Messages: 679
Registered: June 2014
|
Senior Member |
|
|
Hi tingjenc,
Structures are stored as canonical text string (idcodes). Thus, unless you intend to merge different stereo isomers or tautomers, you don't need to use canonical codes for merging. When merging, only the second file's key column(s) need to be unique. You could try a couple of things:
- change the order of your files. Possibly, one of the two files has unique structures.
- before merging the second file, you could "Data -> Merge Equivalent Rows" selecting 'Structure' as criterion. After that merging both files using 'Structure' should work.
- To find and display your duplicate structures within the second file you could "List -> Create Row List From -> Unique Rows" using the 'Structure' column. Then, select 'unique rows' in the new list filter, invert the filter, and click on the 'Structure' table header to sort by Structure. Redundant structures are now shown together.
- Instead of merging, you could use 'Chemistry -> Find Similar Compounds In File...". Here you can define a similarity limit using any descriptor rather than using an exact structure match, what merging does.
Hope, this helps...
|
|
|
|
Search
Help
Members
Register
Login
Home
