You are here: In-Database > Union In-DB

Union In-DB Tool

The Union In-DB tool combines two or more In-DB data streams with similar data structures based on field names or field positions. In the output, each column will contain the data from each input.

How to use this tool

  1. Drag a Union In-DB tool from the Tool Palette onto the workflow canvas.
  2. Connect one or more In-DB tool's output to the input of the Union In-DB tool.
  3. With the Union In-DB tool selected, configure the tool using the Configuration window on the left.
  4. Choose the preferred configuration mode. Choices are:
  5. When Fields are Different: Select how to handle nonconforming data fields from the dropdown. Choices are: