Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI tend not to use the Select statement to change data types, especially numbers as my first instinct. Tried it both ways. Definitely more comfortable with formulas. Wonder if Alteryx uses the same methodology to change data types using select (String to Int) or formula using ToNumber function.
My Solution (Standard and Enhanced versions)
Designer Cloud solution
A nice simple three steps in the recipe. Just needed to be careful with the MM/dd/yy date formatting as it was auto-detected as dd/MM/yy
Designer Desktop