Need help with "Join two Datasets" tool

Heads up! This is a static archive of our support site. Please go to help.galaxyproject.org if you want to reach the Galaxy community. If you want to search this archive visit the Galaxy Hub search

Latest

Open

RNA-Seq

ChIP-Seq

SNP

Assembly

Forum

Planet

All »

Home

Welcome to Galaxy Biostar! User support for Galaxy! about • faq • rss

Community

Log In

Sign Up

Add New Post

Question: Need help with "Join two Datasets" tool

3.9 years ago by

aglassing • 10

United States

aglassing • 10 wrote:

Is there a way to do a complete merge with this tool? For my 2 data sets there are going to be rows that are matching and rows that are unique to each file. When I join set 2 with set 1, I want to be able to keep the lines from the second set of data that do not join with the first instead having them deleted. Is that a possibility?

Tool name: Join two Datasets
Tool version: 2.0.2
Tool ID: join1

join-two-datasets • 1.3k views

ADD COMMENT • link •

modified 3.9 years ago by Jennifer Hillman Jackson ♦ 25k • written 3.9 years ago by aglassing • 10

3.9 years ago by

Jennifer Hillman Jackson ♦ 25k

United States

Jennifer Hillman Jackson ♦ 25k wrote:

Hello,

Updated:

The last three options on this tool form permit you to keep lines that are not a match. It is good idea to choose to "Fill empty columns" to keep the column order intact. Note that this keeps lines for the first dataset only.

To obtain a full union, you will need to run the tool twice, then merge the results and remove redundant lines.

Hopefully this helps, Jen, Galaxy team

ADD COMMENT • link modified 3.9 years ago • written 3.9 years ago by Jennifer Hillman Jackson ♦ 25k

I have another update. I created a ticket for our team to consider updating the tool to perform a full outer join. No promises, but the request has been made for review by our development team/community. It is located here:
https://trello.com/c/hjdkKRqy

Best, Jen, Galaxy team

ADD REPLY • link written 3.9 years ago by Jennifer Hillman Jackson ♦ 25k

Please log in to add an answer.

Similar posts • Search »