Join multiple

Having reviewed the Join tool, we'll now focus in on the Join Multiple tool, which is quite like the Join tool. The Join Multiple tool allows for two or more inputs to be joined together and all records to be joined without using a Union tool. Rather than connecting the Left (L) output, J (J) output, and the Right (R) from the Join outputs to the Union tool, the Join Multiple tool can be used to provide an all records output. The objective is to determine which cities have a population greater than 90,000 and an average age between 51-69, the generation known as the baby boomers. This will help to analyze the health outcomes for baby boomers. Three input files will be used to obtain this information. Let's see the benefits of ...

Get Learning Alteryx now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.