Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?


Preparing demographic data for Cluster Analysis


Hi Alteryx experts,


I would like to do a cluster analysis (K-centroids) to identify the customer profiles for each of my three stores. However, only three of the attributes are numeric (Member sales amount, No. of member transaction, member sales quantity). Would it be possible to turn the other ones, such as merchandising category, gender , into numeric values for my analysis? Attached please find the transaction data with basic demographics. Thanks!


VIP Demographic.png






Alteryx Certified Partner

Yes - take those values, and have individual summarise tools for each dimension, gender for example. Then, take a recordID and name it the dimenion but ID, gender_id for example. Then, join that back onto the main dataset and replace the text with the ID value and use that in the clustering. Then, afterwards re-join the ID to get text value back.


Sorry for the slow reply. I am new to Alteryx, and get stuck on the joining the IDs. Could you kindly advise how I should proceed?

2018-06-25 Preparing Demographic Info.png