for some time I have tried (in vain) to figure out the solution to a problem regarding Import from File (txt, sdf) into an IJC entity.
Let's say this entity contains a list A of 100 chemicals identified by CAS number + some additional data fields for these chemicals. Now I want to import data from a second list B which contains data on 50 of these chemicals + data on 50 other chemicals not included in list A (the field structure of the two lists being identical otherwise).
What I would like to do in one go is:
- for the 50 chemicals in both lists: to overwrite the associated data with those in list B
- for the 50 chemicals only in list B: to add these to list A (together with their data).
Actually some 15 years ago this was a standard functionality of ISIS Base which I used back then. However in IJC, I only seem to be able to either update list A with the data on the 50 chemicals in both lists (via the merge function), but not the new chemicals, or to import all of list B, resulting in duplicate records for 50 chemicals.
Alternatively, I would first have to find out which chemicals in B are already in A and which are not, and split my dataset accordingly (which is very tedious).
Probably I have just overlooked something (because it is hard to believe I should be the only one with this problem) and there is a very simple solution?