I was able to tansform your sample without issue. Not sure if the large file is different in some way.
That is so strange why you don't get any error while performing type changes using Locale. I will figure out.
Between, may I know how you enable the two checkboxes (i.e. Column Distribution and Column Quality) as it is cool stuff to find out status of the column. I can't find it Data View pane. Thanks.
I am still having error and therefore, I swtich to traditional way by adding three custom columns and breakdown the Transdate into YYYY, MM, DD and later combine them into Date (text) and finally convert it into the proper date format by using Date.FromText function, and it works.
I means I can transfer the data in excel but I just want to perform this kinds of activities directly in Query Editor in case the file is too large.
I will flag your last feedback as acceped solution and if you don't mind let me now how to pull out those two checkboxes that will be great.
sorry, I was going to mention how to turn it on, but I was running late for a training course. Go to Options and Settings\Options\Preview Features and turn on column profiling.