Pool (deprecated)

This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.

The Pool functionality allows you to combine two databases based on data they have in common. The pool operation compares data from specified fields in the two databases and, when a match is found, combines the related entries. As opposed to importing data from one database into another, pooling databases allows you to mesh related data from different sources in order to form a new database. In set theory terminology, the pool operation provides the proper mechanisms to compute the union, the intersection and the difference of twodatabases.

Options

Key 1 - Port 0
Primary key field in DataTable 1. Only one field should be selected!
Key 1 - Port 1
Primary key field in DataTable 2. Only one field should be selected!
Key 2 - Port 0
Secondary key field in DataTable 1. Only one field should be selected!
Key 2 - Port 1
Secondary key field in DataTable 2. Only one field should be selected!
Key 3 - Port 0
Tertiary key field in DataTable 1. Only one field should be selected!
Key 3 - Port 1
Tertiary key field in DataTable 2. Only one field should be selected!
Import shared entries
Import entries shared between DataTable 1 and DataTable 2
Import unshared entries of DataTable 1
Import entries from db1 that are not shared
Import unshared entries of DataTable 2
Import entries from db2 that are not shared

Input Ports

Icon
DataTable
Icon
DataTable

Output Ports

Icon
Merged DataTable

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

Summary
Displays Runtime Information

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.