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

Herman

2018 Customer Data.xlsx

Sample.yxmd

Error Message

Parse

Join

Predictive Analysis

Demographic Analysis

Accepted answers

BenMoss

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.

Ben

Sample.yxzp

All comments

BenMoss

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

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.