top of page

Alteryx Weekly Challenge #35

Data Cleansing Techniques

https://community.alteryx.com/t5/forums/recentpostspage/user-id/19037

Use Case:

There is a series of data cleansing processes we need to do on our data. Please solve each per the instructions.

Data Set #1 | Vehicle Unit Number: Remove leading zeroes                                                                                                   

Final Data Set Solution #1

Workflow with Detail #1

Data Set #2 | Entity: This is a 4 digit numerical code. Trim leading zeroes and/or descriptive text at the end                                                                                                    

Final Data Set Solution #1

Workflow with Detail #1

bottom of page