Finding groups within groups

In the previous recipe, we mentioned that we’ll be leaving the Tile tool’s Unique values and Manual methods for later. In this recipe, we are going to use them to easily solve some grouping challenges we may encounter, such as the big formula we used in the previous recipe to assign the groups.

The Tile tool will allow us to categorize records based on conditions in a really simple way.

Getting ready

For this recipe, we’ll be using some assets from the previous recipe. You can download them here: https://github.com/PacktPublishing/Alteryx-Designer-Cookbook/tree/main/ch6/Recipe2.

How to do it…

Follow these steps:

1. Open the GroupingData.yxmd workflow (File | Open Workflow | Browse and point it to this recipe’s folder – that is, the WORKFLOW subfolder:

Figure 6.15: The GroupingData.yxmd workflow

2. Drop a Tile tool and connect it to the output of the Formula...