Question: Need help with "Join two Datasets" tool
0
gravatar for aglassing
3.6 years ago by
aglassing10
United States
aglassing10 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.1k views
ADD COMMENTlink modified 3.6 years ago by Jennifer Hillman Jackson25k • written 3.6 years ago by aglassing10
0
gravatar for Jennifer Hillman Jackson
3.6 years ago by
United States
Jennifer Hillman Jackson25k 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 COMMENTlink modified 3.6 years ago • written 3.6 years ago by Jennifer Hillman Jackson25k

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 REPLYlink written 3.6 years ago by Jennifer Hillman Jackson25k
Please log in to add an answer.

Help
Access

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