I am going through your Scenario Method Workshop video. I could not make it in real-time. Anyway, I had issues with the column conversion of Text to Date. The reason is the dates are saved DD/MM/YY and in the US we use MM/DD/YY. I tried
- right-click/Change Type/Date ----- did not work, returned errors
- right-click/Change Type/Using Locale/Date/English (United States) ------ did not work, returned errors
- split column by “/” then arranged in the ordered used here MM DD YY and Merged by “/”. At this point I was able to change the Type to equal Date.
My question is - why didn’t the “Using Locale” work? Is there another way besides Split then Merge?