openmolecules.org

 
Home » DataWarrior » Functionality » multiple database queries (How to pull multiple datasets in where one can reference data from another)
Re: multiple database queries [message #1412 is a reply to message #1399] Thu, 23 September 2021 11:44 Go to previous message
thomas is currently offline  thomas
Messages: 646
Registered: June 2014
Senior Member
Currently, you cannot link a cell of a DataWarrior file to another cell of a different file. Possibly, you can merge your three tables into one DataWarrior file using common identifiers.

A more complicated alternative would be to split the information of files 2 and 3 into small text, html, or even image files located in special folders. If these detail files are named using identifiers used in the first file and if the first file contains information to read detail information from these folders, then the content of the detail files would be shown in the detail area of the first file when moving the mouse from row to row. You could also import the detail text/html/images file content into the first file. The 'flyingObjects.dwar' sample uses this technique.

If you have an HTTP server, which serves detail information using an URL that can be constructed from a general part and an ID, which is part of the first file, you may also define the first file's ID-column to retrieve the respective detail data from the server on request. When running the Wikipedia compounds retrieval, then the file contains backlinks to the Wikipedia page. You can check its 'column properties' section to understand how this is done.

When retrieving Google Patent results, then you get clickable links back to Google servers. You may also check the dwar file for that.

Hope this helps, Thomas

 
Read Message
Read Message
Previous Topic: Box Plot - Statistics
Next Topic: similarity_search_protocol
Goto Forum:
  


Current Time: Thu Mar 28 20:38:01 CET 2024

Total time taken to generate the page: 0.08506 seconds