It really would be great if Alteryx supports the 'set' data type.
I often have situations where I really wish I could make a field with a data type of "set".
For example, I have a table of pets owned by each person.
The "Pets" Field would be perfect if it could be processed as a "set" type.
Person | Pets |
John | Dog, Cat |
Susan | Fish |
(I sort the pet values in alphabetical order, and concatenate the string values using the summarize tool. This is the best I could think of)