Question: Trouble with joining two datasets
gravatar for h.stotz
19 months ago by
European Union
h.stotz20 wrote:

I am trying to join two datasets. Each of the datasets has a row that explains column entries. However, when the two datasets are joined this row gets deleted. This is the first time I am experiencing this. I am not sure how I can solve this problem.



galaxy • 438 views
ADD COMMENTlink modified 19 months ago by Jennifer Hillman Jackson25k • written 19 months ago by h.stotz20

Hello, We'll test this out and have feedback for you on Monday. Thanks! Jen, Galaxy team

ADD REPLYlink written 19 months ago by Jennifer Hillman Jackson25k
gravatar for Jennifer Hillman Jackson
19 months ago by
United States
Jennifer Hillman Jackson25k wrote:


The headers did not match between the two inputs for the columns joined on.

To fix the problem, use the tool Replace Text in entire line (Galaxy Version 1.0.0) on dataset 505 with these options:

  • Find pattern: GO\-ID
  • Replace with: GO

Note: The \ is probably not needed in the "Find Pattern" term, but I usually backslash most non-alpha numeric characters that I want to be read as plain text, just to avoid regular expression issues that can come up with certain tools.

The headers will now be a match between the adjusted dataset and dataset 516. The resulting join includes the headers. The fix is now in your history for reference. You can purge/permanently delete any datasets not needed (the original dataset 505, or any others I created, if you want to do try this yourself).

Hope this helps! Jen, Galaxy team

ADD COMMENTlink written 19 months ago by Jennifer Hillman Jackson25k
Please log in to add an answer.


Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 173 users visited in the last hour