In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities
here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started.
Learn more here
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hi,
I want to calculate the number of times each customer has bought product A, B, C and so on.
The desired input and output are as follows:
Can't seem to figure out how to do this. Please help. Thanks a ton!
Text to Columns tool but set it to Text to Rows. Then use a Summarize tool and group by Customer ID and Group by and Count the Orders. Then Crosstab the results grouping by the Customer ID. If you want the Nulls to be 0's add a data cleanse or Multi Field Formula Tool to the end of the flow.
