◄Show Table of Contents

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.

This is an In-Database Tool.

(missing or bad snippet)

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:
• Auto Config by Name: Aligns fields by field name.
• Auto Config by Position: Aligns fields by their field order in the stream.
5. When Fields are Different: Select how to handle nonconforming data fields from the dropdown. Choices are:
• Error - Stop Processing Records: will throw an error in the Results window, and end the schema.
• Output All Fields: All fields will be included. Null values will populate empty fields.
• Output Common Subset of Fields: Only the fields that each input has in common will be outputted.

Alteryx.com | Community | Customer Support | Documentation Feedback

©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.