core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
My solution:
Used Text to Columns, Formulas, and Select tools to transform data.
Please find attached my solution.
Here's my solution.
Completed Challenge Solution
Hi,
I used the following tools to complete the assignment:
1. Text to column - with delimit ","
2. Formula Tool - with the following functions: Replace, Trim and Datetimeparse
3. Select Tool for heading name.
Regards
G
Here is my wf out!
A few more tools (Data Cleansing and DateTime), learned about the DATETIMEPARSE formula as another approach!
Here's for my solution. 🙂