âShow Table of Contents
The Join Multiple tool combines two or more inputs based on a commonality between the input tables. Only the joined records are outputted through the tool, resulting in a wide (columned) file.
Select how to perform the Join. The two options are by record position, or by specific field.
Join by Record Position: Select this option when the input tables to be joined have the same field structure, and the data will be joined by its position within the two tables.
Join by Specific Field: Select this option when the input tables have one or more field in common (such as an ID) and the data will be joined together.
Choose the preferred behavior for how to handle Cartesian Joins.
Cartesian Joins: A Cartesian join is when you join every row of one table to every row of another table. You can also get one by joining every row of a table to every row of itself. A Cartesian join is very CPU intensive, and is usually done by mistake.
Choices on how to handle Cartesian joins include:
From the configuration properties, you can rename fields, reorder fields, sort ascending/descending, and select the fields needed from the inputs.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered trademarks of Alteryx, Inc.