Latest
Open
RNA-Seq
ChIP-Seq
SNP
Assembly
Forum
Planet
All »
Home
Log In
Question: Trouble with joining two datasets
0
gravatar for h.stotz
19 months ago by
h.stotz • 20
European Union
h.stotz • 20 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.

Thanks,

Henrik
galaxy • 438 views
ADD COMMENT • link •
modified 19 months ago by Jennifer Hillman Jackson ♦ 25k • written 19 months ago by h.stotz • 20

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

ADD REPLY • link written 19 months ago by Jennifer Hillman Jackson ♦ 25k
0
gravatar for Jennifer Hillman Jackson
19 months ago by
Jennifer Hillman Jackson ♦ 25k
United States
Jennifer Hillman Jackson ♦ 25k wrote:

Hello,

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 COMMENT • link written 19 months ago by Jennifer Hillman Jackson ♦ 25k
Please log in to add an answer.

Similar posts • Search »

Content
Help
Access
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