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.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackMy solution
quick and easy one, but useful because I hadn't used this tool yet.
DateTime tool creates new column with converted field.
Given that I would use the Select tool early on, I placed DateTime first, to avoid extra operations.
Assuming potentially more rows, I generally use Data Cleansing tool to Remove Unwanted Characters: Leading and Trailing Whitespace and Tabs, Line Breaks, and Duplicate Whitespace.
Any suggestions on how (if) this could be more efficient? :)