Blue icon with a double helix.

Union In-DB Tool

Last modified: September 25, 2020

Use the Union In-DB tool to combine two or more In-DB data streams with similar data structures based on field names or field positions. In the output, each column contains the data from each input.

In-Database enables blending and analysis against large sets of data without moving the data out of a database and can provide significant performance improvements over traditional analysis methods. For more about the In-Database tool category, see In-Database Overview.

Configure the Tool

  1. Choose the preferred configuration mode. Choices are:
    • Auto Config by Name: Aligns fields by field name.
    • Auto Config by Position: Aligns fields by their field order in the stream.
  2. When Fields are Different: Select how to handle nonconforming data fields from the dropdown. Choices are:
    • Error - Stop Processing: Throws an error in the Results window, and ends the schema.
    • Output All Fields: All fields are included. Null values populate empty fields.
    • Output Common Subset of Fields: Only the fields that each input has in common are output.
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.