Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Convert demographic info to numeric values for predictive analysis

Hi All,


I would like to convert customer demographic info to numeric values for predictive analysis. For example, gender will convert from "M" to a number. I am not too sure if this is the correct way to do it, but I have been trying to use the summarize tool and record ID tool to accomplish this. However, I got the N-Dimensional join error when trying to join the IDs (likely because the customer master code appears more than 1 time in the column). Could you please advise what I should do? Thanks!


Picture 1.png




Alteryx Certified Partner
Alteryx Certified Partner

Hi @cheunghm4532 for future reference if you are including the data in the post you can use a 'packaged workflow' which includes the data already mapped into the alteryx workflow saving us time and effort when building a solution for yourself.


You can achieve this by going to 'options' > 'Export Workflow' and ensuring all the assets are selected.


I just looked at your workflow and I believe the error you got was the result of trying to use the 'join multiple' tool which does not make sense in this scenario. Your ID is unique for the specific dimension.


Instead you want to perform a simple join, several times, as in the image below. You could create a macro to do this but in your case I kept it as simple as possible.


Example workflow attached.





Thanks Ben,


However, I encounter the below error when trying to open your file. My Alteryx version is 11.7.


Picture 2.png



Alteryx Certified Partner
Alteryx Certified Partner

i'm going to step you through the process to downgrade the file, you can try this, if your still stuck then I can do it!


1. Download the .yxzp file

2. Convert the extension of the .yxzp file to .zip (simply rename)

3. Extract the contents of the zip file

4. Identify the workflow file (.yxmd)

5. Open the workflow in notepad

6. Find line 2 and identify where it declares the version "2018.2"

7. Overwrite 2018.2 with 11.7

8. Save

9. Open in Alteryx



Hi Ben, I just downloaded the latest version of Alteryx, and your workflow works for me now! Thanks!