Hi all,
I'm quite new to Alteryx and would like to know if someone can help guide me or provide examples to clean this dataset. This data is too hard to me to clean as I'm just a beginner.
I know that I need to combine all of the data from 2014 to 2021 into one. Should I pivot the data and do Vlook up? What should I do? Thank you for your time!
https://tinyurl.com/eeocdataset
Downloads
There are also some labels under page 6-12
Solved! Go to Solution.
That's a pretty big ask - let me see what I can do... The downloads for the data are quite slow, so please bear with me.
Please have a look. I've combined the datasets for you and cleansed the * in numeric values to be 0s, and changed the data type to Double.
Now, what else do you want to do with the data? That part is still a blur to me.
Hi @caltang What should I do first? Thank you! What do you want me to clarify?
@caltang I can't open yxdb file. what should I do?
You are not supposed to open the YXDB files, rather, you should use them as inputs in one folder location so that the workflow exported to you can work. Because the input method used is a Directory Tool, you need to do the following:
Kindly follow the steps above.
OK - What do you want to do with the data? What is it that you want to clean? Can you be clearer in your requirements?
Let me know what exactly you want to do with the data - then let me either build it for you or advise you how to build it.
@caltang how do I add years here and eliminate some of the nulls?