Alteryx designer Discussions

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

my assignment- data cleaning

7 - Meteor

Hi All,


I have done basic course training using YouTube and i did one sample data cleaning poc. Please find the attached data and alteryx programm .


Please review and let me know is there better process than this.




12 - Quasar
12 - Quasar

Hey @ysreenumba 


Welcome to the Alteryx community! I am excited to see you working honing your skills. Typically, the community is designed to tackle specific questions of problems that arise and discussions around different ways to solve a particular problem. If you are looking for some example problems and a variety of solutions attached to them, I would suggest you check out the Weekly Challenges as a large part of the community participates and enjoys the discussion.


That being said, I look at your workflow and want to point out a few things. 


  • You don't really need Formula(5) because all you are doing is replacing all blanks with "1" and then in the next filter tool, just filtering out all records with the value of "1". You can just change that formula to say "[Course content] != '' or [Course content] != 'Preview'"
  • If you follow the step above, you can get rid of Select(11)


Let us know if you have any more specific questions.