This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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.