![]() This is probably the tool we get most support questions on, it’s a complex tool and it isn’t immediately obvious how to use it. Remember that if we simply want to know the maximum Profit per Product Category then we could use a Summarize Tool, grouping by Product Category and selecting the Maximum Profit will produce that result, however the Unique tool has the difference that it keeps all the fields, the Summarize Tool will only keep the aggregations you specify. If we have first sorted a recordset based on a Profit field descending, then did a unique on the Product Category, we would get the highest record with the highest Profit for each Product Category. ![]() This means that sorting is incredibly important if we want to control the output. For the field(s) selected the tool groups the rows based on those fields (sorting on them in the process), then takes the first row of each group into the U (Unique) stream, the remaining rows go into the D (Duplicate) stream. The unique tool is a Data Preparation tool, and as you can imagine from the name it’s function is to return a unique dataset for the fields provided, though I think a clearer name for the tool would be “First Distinct”, because that’s essentially what the tool does. Alteryx Tools in Focus: Fuzzy Match, Make Group and UniqueĪlteryx has a vast number of tools, and it’s easy to miss some functionality that might be useful, so for this new series of blog posts we’re going to take readers through three tools per blog post, detailing functionality as well as hints and tips for each tool.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |