I have a field of numbers with the following values: 1, 1, 2, 3, 4, 4, 4, 5 I would like to generate an output which only contains the numbers which are NOT duplicated. My ideal output would be: 2, 3, 5 When I use the Unique tool I get 1, 2, 3, 4, 5 on the U anchor and 1, 4, 4 on the D anchor. Is th...

I have data with the structure in the attached file. How can I make it look like the second file as concisely as possible? Whenever I try to use Crosstab tool it tries to sum or concatenate.

For example, will 'marketing' from one input join with 'MARKETING' from another input or not? If not, what is a quick work around to get them to join properly?

Hi. I'm new to Alteryx and built a macro that saved as a .yxmc file. I see it in my file explorer, but I am unsure of how to quickly insert it into my workflow. I don't see it anywhere on the toolbar! Please help!

I have some order data that I want to combine with every possible combination of products, grouped by order ID. That way I can show the products that most frequently appear together on the same order. It looks something like this: OrderID ProductID 1 3 1 7 1 4 2 5 2 8 2 6 and for analysis I want to ...

I am wrapping up a project with multiple workflows and many inputs/outputs. I need to change all of the paths to be relative, however doing this by hand will take hours. Is there a way to do this quickly?