Filter rows based on a selection list.

Extract rows with a selection list.

Remove rows based on a list selection.

Align two tables.

Find tables intersection.

Filter rows based on a list selection.

Extract rows by column values matching between two tables.

Your browser does not support SVGs

Two-table Operations

molbiotools.com

quick hints useful linx send feedback user guide
Display quick hints Useful links Send feedback! User guide

Input A

Input B

Table Preview

Output Data
Delimiter: Quoted values

ACTIONS

Reading data (necessary)

Delimiter A:

First row is a header (will be ignored)

Delimiter B:

First row is a header (will be ignored)

Extracting rows with a selection list

Reference column in A:

Row order:

As in A
As in B
Your browser does not support SVGs

Removing rows with a selection list

Reference column in A:

Your browser does not support SVGs

Extracting rows by reference columns match

Reference column in A:

Reference column in B:

Your browser does not support SVGs

Merging tables by reference columns difference

Reference column in A:

Reference column in B:

Your browser does not support SVGs

Aligning two tables

Reference column in A:

Reference column in B:

Row order:

Sort matching rows to the top
Keep the order of A
Your browser does not support SVGs

Additional settings

In case of very large tables (many thousands of rows), the table preview (not the data) needs to be limited to pre-set maximum numbers of rows and columns to prevent slowdown or even freezing of the app. Some patience still may be needed with bigger data.

Maximum number of rows in preview:

Maximum number of columns in preview:

Your browser does not support SVGs


DISCLAIMER: This free software comes without any warranty. The author of the software bears no responsibility for any loss or damage that may arise from its use for any purpose.

QUICK HINTS