TIP: If your data is not TAB delimited, use Text Manipulation->Convert

Syntax

This tool finds lines in one dataset that HAVE or DO NOT HAVE a common field with another dataset.

Example

If this is First dataset:

chr1 10 20 geneA
chr1 50 80 geneB
chr5 10 40 geneL

and this is Second dataset:

geneA tumor-suppressor
geneB Foxp2
geneC Gnas1
geneE INK4a

Finding lines of the First dataset whose 4th column matches the 1st column of the Second dataset yields:

chr1 10 20 geneA
chr1 50 80 geneB

Conversely, using option Non Matching rows of First dataset on the same fields will yield:

chr5 10 40 geneL